Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Edit: (Should also be 48, not 56)
Nevermind, got it!
Count({1<DateField={">=$(=Date(Max(DateField)-48))"}>} Event_Id)
Edit: (Should also be 48, not 56)
Nevermind, got it!
Count({1<DateField={">=$(=Date(Max(DateField)-48))"}>} Event_Id)
You can mark your response as correct answer