Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want to sort data in chart according to chronological week range. For Ex - 6/Jun 25/Jul 8/Aug.
I used calculated dimension for Week Range and Week Start Date - Date(WeekStart(TransactionDate),'MMM/DD')
Any help would be appreciated.
Regards,
Neha
have a look at the attached sample.
I used a mastercalendar to generate a field "WeekDiff" for Sorting!
notice: in chart --> sort --> expression = WeekDiff
hope this helps
have a look at the attached sample.
I used a mastercalendar to generate a field "WeekDiff" for Sorting!
notice: in chart --> sort --> expression = WeekDiff
hope this helps
Hi,
Try to do a calendar dimension like this:
CALENDARIO:
Load
date
,week(date) as Week
Resident XXX
Order By date ASC;
And order the result by "Week" field.
Regards.
Hey Frank,
Thanks
Best regards,
Neha