I’m trying to do a calculation where I get the average of a particular period of time.
This has to be automated. I need the calculation to take the last 6 months data and ignore the previous 2 months data.
I cant do this at the table level because of the other part of this calculation.
If i did this at the table level, would it be possible to also have a sum over and say this calculation only took into account the last 2 months data thats being excluded from the top?
You could use the calculated field below if you want to get the average of a field called {measure} where the date field called {date} has values between 6 months ago and 2 months ago: