Forum Discussion
Rolling average for categories.
I have data in form of three columns (Date, Incidents and Department). I want to calculate a rolling average measure for a chart which has departments in rows, incident sum for each month and finally...
johnt75
Super User
Super UserIf I understand correctly you want a visual which has departments on the rows and shows the average incidents over the last 6 months. Using the method from the video you can add a visual filter to the table so that the date is in the current month. that will then work out the average over the last 6 months.