Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
so i have a line chart, where i should sales and stores.... there are over 200 stores.
I deleted the labels of the x axis, but I would just like to mark some specific points, let say, that i would like to mark the first 15 stores as a, the following 45 as b and then c... they are sorted according to the sum of sales... how could i do that?
thanks
If(aggr(rank(sum(sal) , store)<=15, a,
If(aggr(rank(sum(sal) , store) >15 and aggr(rank(sum(sal) , store) <=45, b, c))
but where do i write that formula?
Hi @Nemo1
I'm not quite following what you are aiming for here. You say it is a line chart, but you are showing stores? Line charts should only be used when you have a continuous numeric dimension, such as date.
Your best bet for marking values on a chart is probably to use the Colour property, under the Appearance menu, with an expression something like:
if(rank(TOTAL sum(Sales),2,1)/count(TOTAL DISTINCT StoreNo) <= 0.1, rgb(180,0,0),
if(rank(TOTAL sum(Sales),2,1)/count(TOTAL DISTINCT StoreNo) <= 0.3, rgb(0,180,0), rgb(0,0,180)))
That is assuming the categorization is as per your other ticket? If not, remove the division and compare the rank values to 15 and 45 accordingly.
Hope that helps.
Steve