Need to sum of items based on values to show in aggregated Pie chart

[ajitsingh]

Hi All,

I need to implement in Appsheet aggregated Pie chart view. For example we have following values in one of column as 2, 15, 3, 2, 1, 8, 8, 12, 17, 3, 2, 7, 18, 20, 30.

Now I need to show so these values in Pie chart view with just 2 category..

1 - all values count which are less than 10 (9 counts)

2 - all values count which are greater than or equal to 10  (6 counts)

Please help me

Thanks in Advance

Ajit Singh

[Suvrutt_Gurjar]

Please create a virtual column called say [Count Category] with an expression something like 

IF([Column] <10, "Below 10", "Equal N Above 10")

Then you can have the aggregate pie chart based on this [Count Category] column. For example, in the Chart column setting below, you would enter [Count Category] and Group aggregate setting as "COUNT"