Top and Bottom Customers show together in bar chart.

rupaliqlik — Mon, 27 Sep 2021 06:42:37 GMT

Hi Team,

I want to show Top and bottom N customers with positive gap and negative gap. But there are around 60 customers so scroll is coming. User don't want scroll. How to to show top or bottom 10 customers together in bar chart. Also I am calculating variance by subtracting MTD ACT master item - MTD LO master item.

MTD ACT - MTD LO

Best Regards,

Rupali

Re: Top and Bottom Customers show together in bar chart.

abhijitnalekar — Mon, 27 Sep 2021 12:39:06 GMT

Hi @rupaliqlik ,

Please try below setanalysis.

Please try below set analysis.

=if(
aggr(rank(-Sum(measure)), Diemsion) < 10
or
aggr(rank(Sum(measure)),dimension) < 10
, dimension)

Hope this solve your purpose

topic Re: Top and Bottom Customers show together in bar chart. in App Development

Top and Bottom Customers show together in bar chart.

Re: Top and Bottom Customers show together in bar chart.