1 of 1 people found this helpful
You are absolutely correct in that it is a custom calculation. You need to use WINDOW_AVG or RUNNING_AVG and multiple mark types. In order to be more specific, I would need to see a copy of the workbook. Could you upload a .twbx file?
Thanks Brad - I think between your and Josh's comments I have it figured out. I think the multiple mark types was the concept I was missing at first.
If I get stuck again I will dummy up a workbook file and send it over.
Thanks Josh - this is great. I think I have it figured out.