Week Range Sorting in Cyclic Group

[nehasaxena]

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

[Frank_Hartmann · Accepted solution]

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

[enriquem]

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.

[nehasaxena]

Hey Frank,

Thanks

Best regards,

Neha