Percentage line chart issue

[Anonymous]

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!

[sunny_talwar · Accepted solution]

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)