Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Gays how I can sort by date?
How You can see in the picture, I am not able to sotr by date, someone can suggest me some expression or how I can do it?
I have 1 dimension and 2 expressions that are a count of a value.
Thanks for any helps
Seem to making heavy weather of a small problem.
=Date(The_Date, 'MMM dd')
And sort it numerically
why the '' in the middle? This isn't needed. You can create a dual() in which you put the Num of the month and day as the number which you can use to sort.
why are you using Month&Day as dimension value ?
are you sure you don't need also Year ?
He might filter on this year only already.
Sorry but I dont need year, I have to compare value from different years
Could you please give me an example of it? I will appreciate..
Thanks
if you just selected a Year you can use the below expression on Sorting dimension section:
check "Sort by expression" and type "The_Date" plus Ascending order.
The problem is that if I use the year, the data that I need to compere it will show not in the right way. I mean if I have value X with data 02.02.2016 an value y with data 02.02.2017 I would see the two bar on the same day and month in order to compare.
Hope that you understand what I mean
Hi Bram, If I change the expression as :
=Month(The_Date)+ day(The_Date) I have the data as a Number format.. Now maybe I need just to see the correct format of the data, and I think that the sort will work..
Any suggestions?
No body have an idea about it?