Hi QuickSight Community,

My dataset:

Student | Course | Questions | Answered |
---|---|---|---|

A | X | 123 | 67 |

A | Y | 222 | 55 |

B | Z | 999 | 234 |

B | W | 808 | 789 |

C | X | 123 | 0 |

D | W | 808 | 808 |

E | Y | 222 | 101 |

avgOver(avg(Questions), [Course]) →

Course | Questions | Participants |
---|---|---|

X | 123 | 2 |

Y | 222 | 2 |

Z | 999 | 1 |

W | 808 | 2 |

Total: 123+222+999+808

Is there any way to get the total number of questions in all courses if sum(avgOver(…)) is not allowed?

Having a dataset that doesn’t include participants is not an options because some filters/controls are in place. E.g. filtering by students from EMEA would change the total number of questions from 123+222+999+808 to 123+808 because there are no students from EMEA in course Y and Z.

I hope it makes sense. I’d appreciate any kind of help!

Thanks,

Adrian