Charts with aggr function

[#1]

Hi everyone,

I have the simple attached app, I want to be able to create bar chart or pie chart to see the median of values per category for each ID in each city. Can someone please help? Should use two aggrs but not sure how I can do it and display in charts

Thanks!

[#2]

I also want to be able to do filtering by ID after creating the charts...

[#3]

Hi,

Are you able to provide a screenshot of what the end result should look like.

[settu_periasamy · Accepted solution]

May be like attached?

You can concat the City & ID in the calculated dimension and put the expression 'Median(Value')

[muthukumar77]

Hi,

Yes we need to use two dimension. Use expression like this,

aggr(median(Value),ID,City)