I want to get the Last 8 weeks Of Data not Including Current Week?

[jamiemcc]

Hi Guys,

I want to get the last 8 weeks of Data but i don't want to Include the Current Week.

Here is what i have:

sum({<DailyTaskType = {'Counts'},Tier = {'Tier 1','Tier 0'}, Week = {">=$(=Max(Week)-8)"}>}EstimatedTaskTime*Tasks)

If anyone has any input that would be greatly appreciated. 

Thanking you in advance

Jamie

[jamiemcc]

 I also Have this 

set Analysis:

sum({<DailyTaskType = {'Counts'},Tier = {'Tier 1','Tier 0'}, Period = {">=$(vPR4Weeks)"}>}EstimatedTaskTime*Tasks)

Variable: Let vPR4Weeks = WeekStart(Today()-(7*8));

[sunny_talwar · Accepted solution]

May be just this

Sum({<DailyTaskType = {'Counts'}, Tier = {'Tier 1', 'Tier 0'}, Week = {">=$(=Max(Week)-8)<$(=Max(Week))"}>} EstimatedTaskTime*Tasks)

[jamiemcc]

Thats it, 

Thank you so much 🙂

Jamie