Sort expression with Rank

[dana]

Hi,

My table displays deviations in ascending order. 

I have a calculated DateTime dimension for the top 30.

I use the following sort expression on the DateTime dimension  based on rank:

When the rank is equal, I would like the dates to be in ascending order. 

Any ideas how it can be done?

Thanks in advance!

[chrismarlow · Accepted solution]

Hi,

Can you add a secondary Rank with suitable divisor to split the rank out, something like;

Cheers,

Chris.

[dana]

Great idea! Thanks!

I needed to modify the timestamp to a number in order for it to work:

Year(DateTime) & Num(Month(DateTime),'00') & Num(Day(DateTime),'00')&Num(Hour(DateTime),'00')&Num(Minute(DateTime),'00') as DateTimeNum

And the sort expression is:

Rank(Sum(Value))  + (Rank(DateTimeNum)/1000)