topic Re: pie chart view data in App Development

pie chart view data

naamah — Mon, 28 Nov 2022 09:22:34 GMT

Hi,

I user pie chart with the default of 10 slices and 'Others'. But when I choose 'View Data' (a pivot displayed instead of the chart), I want to display every particular value under 'Others' . Is there any way to do this?

Re: pie chart view data

kaushiknsolanki — Mon, 28 Nov 2022 10:18:44 GMT

I dont think so that is possible, you may have to try some different way to achieve that.

Re: pie chart view data

vinieme12 — Tue, 29 Nov 2022 08:54:26 GMT

This is possible by using a calculated dimension

Example

using dummy data

in data load editor Press CTRL + 00(press 0 twice) to generate dummy data

In Chart use dimension

=aggr(if(min(total aggr(rank(sum({<Alpha=>}Expression1),4,2),Alpha))>10,Alpha,if(rank(sum({<Alpha=>}Expression1),4,2)<=10,Alpha,'Others')),Alpha)

Expression

sum(Expression1)

Re: pie chart view data

naamah — Tue, 29 Nov 2022 12:06:20 GMT

Hi Vineeth

this is real greate, thank you!

i would like to challange you 🙂 ...when i view data i want it to display all values. means all the others but also the top 10...

thanks!

Re: pie chart view data

vinieme12 — Wed, 30 Nov 2022 03:47:08 GMT

why not use a container instead?