Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart with year quarter as a dimension and I want to show rolling 12 in each quarter.
If I use aggr and rangesum the last quarter will be right.
How can I do this?
I don´t have the as of calendar.
Regards
Jenny
If you use quarter-year as dimension you'll need an asof table. See this document: Calculating rolling n-period totals, averages or other aggregations