Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
First of all, thank you so much for reading my post and potentially help me figure this out!
I am trying to create a chart that shows the percentage of fruit consumed throughout the day between different groups. I have figured out how to many the chart (having the dimensions be listed as: 'hour' , 'group_of_campers' and then the expression be
"sum(fruit_count)/sum(total <group_of_campers> fruit_count)").
However, when I select on a particular hour, the percentage in the graph changes to be 100%. I would like it to remain being the percentage that is actually consumed, so if 50% is consumed at noon, when I select at noon, the chart would still show 50% (not the 100% because noon is selected).
I think I might need to use set analysis for this, but am still not entirely sure how to set this up. Any and all help would be most appreciated!
Thanks!
I think all you need is to ignore selection in Hour field for your denominator expression
Sum(fruit_count)/Sum({<hour>}TOTAL <group_of_campers> fruit_count)
I think all you need is to ignore selection in Hour field for your denominator expression
Sum(fruit_count)/Sum({<hour>}TOTAL <group_of_campers> fruit_count)