Set Analysis question - rolling dates

[Anonymous]

Hi,

I'm trying to limit a bar chart to show only the past 8 weeks worth of total Events. Have googled lots of responses and found ways of restricting to a date range, but not really a solution that acts like a rolling 8 weeks.

It works fine without the "-56" to get me the latest date, but as soon as I put -56 in, it doesn't work. Then I tried wrapping a Date function around the =Max...-56 but that didn't work either. I think I'm getting the syntax wrong?

Count({1<DateField={">=$(=Max(DateField)-56)"}>}  Event_Id)

Was hoping someone could help?

[Anonymous · Accepted solution]

Edit: (Should also be 48, not 56)

Nevermind, got it!

Count({1<DateField={">=$(=Date(Max(DateField)-48))"}>}  Event_Id)

[Anil_Babu_Samineni]

You can mark your response as correct answer