Sorting timestamps

[tka_ovako]

Hello.

I have scrip that link Year and Month:

num(Year (timestamp(max(EventEndDate)))) & num(Month (timestamp(max(EventEndDate))))  as EventEndYearMonth

however in chart I get wierd compination:

After 20169 come 20171  and after 20182 come 201610 an so on. I know this is some kind onf soting problem but how I fix it?

BR

Timo

[Clever_Anjos · Accepted solution]

Please try with

Year (timestamp(max(EventEndDate))) *100 + Month (timestamp(max(EventEndDate)))

[YoussefBelloum]

Hi,

try to set the sorting of your dimension to: numeric value ascending

and uncheck the rest

[chinnuchinni]

Use below script for Month,You will get your require result

=num(Month (timestamp(max(EventEndDate))),'00') 

[chinnuchinni]

=num(Year (timestamp(max(EventEndDate))))&num(Month (timestamp(max(EventEndDate))),'00')  as EventEndYearMonth

[tka_ovako]

Thank you Clever. That Works. Also praveen's solution seems to work!