Forum Discussion
Rolling 12 Month Trend Line when selecting a month
I was able to accomplish similar to what you are wanting using the fine article below (has a working example as well)
Good luck,
You'll have to specify another coumn to sort your month name by, say a numerical MonthOfYear field populated with 1 through 12 depending on the month name for the row
You can do this in either the "Report" or "Data" view, by selecting the table then the field you are using in those visualizations, then in the Modeling tab select "Sort by Column" to specify your sort column
Super UserYou'll have to specify another coumn to sort your month name by, say a numerical MonthOfYear field populated with 1 through 12 depending on the month name for the row
You can do this in either the "Report" or "Data" view, by selecting the table then the field you are using in those visualizations, then in the Modeling tab select "Sort by Column" to specify your sort column
Ok, thanks, both of you guys have gotten me to get the 12 month rolling Trend to work. But I do have another question. Not sure if thsi should be a new post or not.
One of the measures I want to have as a rolling 12 month measure is a calculation. I'm not sure how to break this up, or do this. The calculation is a Percentage calculation. That goes something like this:
Percent = ((Rolling 3 month T sum) * 12 / 4)/ (Rolling 3 month H sum)
Currently I have a measure that calculates the 3 month t sum and the 3 month H sum. Although I'm not sure how to pull this into the calculation they have in the above link...