Top Customer charts

[manojkulkarni]

Good morning everybody,

We have one requirement, in which we need to show top 10 customers in one chart & second chart should show top next 20 customers (i.e 11 to 30).

First chart i.e top 10, i would manage by using dimension limit. But how to achieve the second chart which should show customers 11-30 ?

[Anonymous]

PFA

[manojkulkarni]

Thanks for you solution. Is there a way to create charts without using calculated dimensions.

[sunilkumarqv]

You can achive these in Dimesion limits

go chart properties, Dimesion limits tab check the  Restrict which values  are display using the first exp ,show only

based on first ,  largest ,smallest  make values

for example  for top 10

show only

largest   10 values

and for second 11-30

change value to smallest 20 values

[Anonymous]

Then you have to calculate them at script level,

you can assign values at script only.

[manojkulkarni]

script level cann't be calculated. Bcz this will change on the basis of selection.

[manojkulkarni]

not working..

[Anonymous]

PFA new file with SCRIPT LEVEL calculation

[sunilkumarqv]

As of the Manoj reqiurment for him need without calculated dimensions.

not reqiured to calculate in script we can make in use of experssion

[Anonymous]

PFA

ALSO ADDED AT EXPRESSION LEVEL..