Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a list box which gives an option of selecting Top 5,Top 10 and All values.
Can someone help me what the logic to create.
My data is in below format:
Load
Country,
State,
Sales
from
abc .table;
Hi,
Hope the attached file will help.
In any single chart create the three variables
For Top 10
=if(aggr(rank(sum(Sales)),States)<=10,sum(Sales))
For Top 5
=if(aggr(rank(sum(Sales)),States)<=5,sum(Sales))
all Values
Sum(Sales)
and one inline table for selection, after all this conditionally load the expressions for more see the sttached
Thanks a lot, it works.
Hello Vijaya ,
First Create buckets of Top 10 ,Top 5 and All value in Backend Script by Using nested If
i.e If(aggr(rank(sum(Sales)),State)<=10,'TOP-10',
if(aggr(rank(sum(Sales)),State)<=5,'TOP-5',
if(aggr(rank(sum(Sales)),State)>10,'ALL-Value'))) as TOP
Then take TOP Field as FilterPlane / ListBox
Good to hear. Please close the thread by marking the helpful/ Correct answer.
It seems you got the answers from the thread may be close the thread with appropriate answers.
Hi Vikas,
Can you please share an example with above script.
Hi Anand,
It works for single table,but I want this to be applicable for all charts and tables in my dashboard.
So should I write this expression in all charts?
Could please advice me how to work on it.
Hi Vijaya
Can u Please share the DataFile