trend weekly count 30 last days

[Anonymous]

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 .

[MK9885]

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.