How to get last week value in set analysis??

[Anonymous]

Team,

I could get value for current week sale , but in my scenario i need to get value for last week sale so i need to use [week date] - 7 in my set analysis !

Please share your thoughts!!

[andrey_krylov · Accepted solution]

Hi, Ashok. Try this set analysis

{< [YourDateField] = {">=$(=WeekStart(Today() - 7))<=$(=WeekEnd(Today() - 7))"} >}

[Anonymous]

Thanks for your response Andrey! will try and get back to you!

[Michiel_QV_Fan]

Do you use a master calendar?

Add a week id to that with autonumber: autonumber(Year(Date)&Week(Date)) as Week_ID.

this will give a sequencial number starting from the first date (be careful with week 53, is it in the old year or the new .....)

Use this in your set analysis:

Sum({<Week_ID = {"$(=max(Week_ID)-1)"}>}whatever)

[venkym1997]

Hi Andrey ,

I have scenario where we don't have dates for weekends and I want calculate average for last 7 data points 

The above expression will work if dates are in sequence like 3,4,5,6,7,8,9

In my case dates are like 3,4,5,6,9,10,11 , how can I achieve 7 days avg here?