Sequential number instead of Dimension values

[divya_anand]

Hi,

I am working on a line chart which has ID on X-axis and "no of days open" on Y-axis.

I am trying to name these IDs in numbers like this-

Any idea as to how to name these IDs in numbers?

[tresesco · Accepted solution]

This?

Exp (using sortable aggr()):

=Aggr(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4,1),(ID,(sum({<Class={'A'}>}num(today())-num(Date)))))

[divya_anand]

Hi Tresesco,

This is brilliant! Thank you so much!

Just 1 tiny thing - Is it possible to show only distinct values in here? I tried using distinct, but couldn't get it right.

[divya_anand]

Or is it possible to number them 10,11,12 instead of 10, 10, 10?

[tresesco]

Putting Num() around like:

=Aggr(Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)),(ID, (Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)))))

Should have worked, but for some reason (I could not find out yet) few overlapped ranks are not getting sorted that way.

[divya_anand]

Tresesco,

Ok, I will give it a try.

Thank you very much.

[divya_anand]

Hi Tresesco,

This is exactly what I was looking for, it worked perfectly for me. Thank you so much!

=Aggr(Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)),(ID, (Num(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4)))))