We had a client recently who wanted to add up graph values for the last 12 months. “Can envisage do that?” she asked.
You bet! Here’s how it’s done:
Let’s say you wanted to know the total income from the last 12 months.
Keep in mind, this is what we call a rolling statistic. Every week or month it will automatically update to include only the last 12 months.
First step is to create a new calculated graph, 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 requires we add 52 weeks to the formula (this can be a little tedious, so reach out if you need help.)
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.
The thing to keep in mind is this — once the data is inside envisage, anything can be accomplished!
If you need help let us know, we offer full onboarding for your entire team.
oOo
Know how to grow with envisage! The world’s first Growth Management System™ Application with Statistics, Org Charts, Objectives, Trends, Events and Reports. Try for free on a no-risk 14-day trial. We’ll even help you set up all your existing statistics to make sure you succeed in getting your business onto Envisage.
Comment and ask questions below or ask questions privately.