previous 13 weeks of data

[#1]

Dear Community,

I'm trying to display a graph that has weeks as the dimension - the graph should only ever show 13 weeks of data regardless of the selections made (based on the maximum date value)

I've set up the appropriate variables and set analysis so that the correct date range is captured, however the order of my week dimension seems to be completely random. I'm not sure what sorting expression i can include to display the weeks correctly?

Sorting on the numeric value of the week works best but does not work when week 5 is selected (as the previous 13 weeks include week 52 from the previous year.

Below are some screen shots:

Sorting by numeric value

Sorting by Date

Please help!!

[yura_ratu]

Please attach an example. There are several ways to achieve it, depending from your data

[#3]

Sorry - attached is an example

[yura_ratu]

Hi Drew

Little change on Sort tab.

Also i did a little change for Min date variable calculation. Your was correct, however the first week on your graph always will be not complete and useless to compare with the next one. Use it on your own judgment

[#5]

Hi Yuriy,

Thank you very much for your help but I'm afraid you are encountering the same issue as me - if, on your example, you select 2015 as the year. The "2014" data which is shown due to the set analysis displays as 49, 52, 50, 51.....

This is the issue i am encountering!

Many thanks,

Drew

[yura_ratu · Accepted solution]

Try again. Copied your set analysis from expression to sorting function. Should work

[#7]

PERFECT!!!!!!!!!!!!!