Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This?
Exp (using sortable aggr()):
=Aggr(Rank(sum({<Class={'A'}>}num(today())-num(Date)),4,1),(ID,(sum({<Class={'A'}>}num(today())-num(Date)))))
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.
Or is it possible to number them 10,11,12 instead of 10, 10, 10?
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.
Tresesco,
Ok, I will give it a try.
Thank you very much.
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)))))