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?