trend weekly count 30 last days

Anonymous — Tue, 30 Oct 2018 09:40:30 GMT

Hello community,

I want to calculate the 30 last days with trend weekly I calculated the last 30 days on script

and I used this formula

sum({<[Calculation Method]={'WTD : -30D : P'},

[Report Date]={'>=$(=WeekStart(Max([Report Date]),-24))<=$(=WeekEnd(Max([Report Date])))'}>}[Qty Net Sold])

but the result is on my graph I have only the count of last week and not the last 30 days .

Thank you in advance .

Re: trend weekly count 30 last days

MK9885 — Tue, 30 Oct 2018 18:07:17 GMT

sum({<

[Report Date] = {"$(='>=' & Date(Max([Report Date]) - 30, 'MM/DD/YYYY') & '<=' & Date(Max([Report Date]), 'MM/DD/YYYY'))"},

Month, Year, Quarter, Week

>}[Qty Net Sold])

This would give you last 30 days of data from the max date you have in Report Date.