pie chart view data

[naamah]

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?

[kaushiknsolanki · Accepted solution]

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

[vinieme12 · Accepted solution]

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)

[naamah]

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!

[vinieme12 · Accepted solution]

why not use a container instead?