Daniel Muise
01/31/2024, 2:51 AMSELECT COUNT( X )
...and then I can view it in analysis per day where needed, works great.
So, I have another variable Y. My daily Count of X is meant to be a denominator of my daily count of Y. i.e., each day, I need to know how many Ys happen per X.
Metric 2: SELECT COUNT( Y ) / SELECT COUNT( X )
... and again, I can view it easily enough per day where needed.
Lastly, all of my insights that use Metric 2 are subject to filters on variable Z. The filter on Z values should only apply to Y, and not X. That's the part I cannot figure out how to do.
Does anybody know what to do in this case? Thank you!Daniel Muise
01/31/2024, 3:04 AMJoseph Heun
01/31/2024, 3:06 AMDaniel Muise
01/31/2024, 3:38 AMSELECT count({label/Y}) /{metric/Metric 1}
Where
Metric 1: select count({label/X) WITHOUT PARENT FILTER
But it's still not reacting how I'd like. The problem isn't the actual filters, but inherent filtering that's apparently happening inside of widgets independently.
So I have stacked bar graphs that stack Metric 2 according to another variable V. Within each stack layer, the the Metric 1 within Metric 2 is being filtered on the stack layer's V value. This throws off my visualization, as the per-V-value stacks are summing to a height far greater than what Metric 2 would be were I not breaking up the visual into stacksJoseph Heun
01/31/2024, 7:16 AMDaniel Muise
01/31/2024, 5:20 PMJakub Sterba
02/01/2024, 10:47 AMBY ALL {lavel/V}
or BY {label/date.day}, ALL OTHER
.
Tip for troubleshooting: display the chart as table with both components of fraction: nominator and denominator if you want to see the root cause of unexpected results.