'How to ignore some filters but not all at Quicksight
I need to calculate a fraction where the numerator is filterable by dimensions A, B and C but the denominator is only filterable by A and C needs to be pre_agg
Today I'm at this
sum(numerator) / min(sumover (denominator, [C], pre_agg))
If the restriction was for all filters I could use pre_filter but it is not the case. And if I add B at pre_agg level, it breaks the number.
Thx for the help
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|