I'm trying to organize volume data which I have on a daily basis. We commonly analyze this data at the quarterly level for trends. To account for months that dont fit into calendar quarters is there a way to make a trailing three month field?
For example, if the data was from January 2013 to August 2013 I would want Tableau to calculate Q1'13, Q2'13, and then the trailing three month period ended August 2013 (June + July + August) so that each period represents a three month period.
First time posting, thanks for your help in advance!
I hope you found a solution but since I just came across your question. You could possibly use sets to achieve this. Do see the solution in the following blog.