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!
