Let’s say you wanted to know the total income from the last 12 months.
This is what we call a rolling statistic. Every week or month it will automatically update to include only the last 12 months.
The first step is to create a new calculated graph. In this example, we’ll call it “1 year Accumulative Income.”
We then use the offset feature to add up past values, as shown below.
The above example will create a 4-week rolling accumulation graph.
To make this a 1-year accumulation rolling graph, add 52 weeks to the formula:
To make this a quarterly rolling accumulation graph, add 12 weeks to the formula.
The sky’s the limit because envisage can perform any type of mathematical calculation you want.