Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, this is driving me crazy :S I've tried everything that came to my mind, I combining 2 years in 1 chart using just month-day as dimension, but I cannot manage to get it sorted correctly, I'm already ordering by date field in load script and sort property in the dimension, but still, the dates not matching. Those at the end happen to be those days that were reported just in one year but not the other, any idea on how to solve this? Thanks in advance!
Dimension: Month([Report Date]) & '-' & Day([Report Date])
Sort: Expression -> [Report date]
I've also tried to create the dimension as text in load script and sort by load order but I'm getting the same result.
Thanks Manish but it didn't work, it gave me even weirder results
Provide sample data.... please
Here's is the sample file
Change in script as below
date([Report Date],'MMM-DD-YYYY') as [Report Date],
and try again..
can you see the file ...
Hi Enrique,
It is still not sorted correctly
The only change is -dd- by -DD-?
I did it but nothing changed....
if you add the year?
That's not the approach I want to overlap both years in 1 chart
I ran in to the same problem. I used Date(MonthStart(DateField), 'MMM-YYYY') to resolve my issue.