Announcements
cancel
Showing results for
Did you mean:
Creator II

## How to mark specific points in a line chart?

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

Labels (5)

• ### SaaS

3 Replies
Master

If(aggr(rank(sum(sal) , store)<=15, a,

If(aggr(rank(sum(sal) , store) >15 and aggr(rank(sum(sal) , store) <=45, b, c))

Creator II
Author

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