Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member


I'm looking for how to create a chart that shows how my business is performing for the last 12 months at each month-end for a set period. For example, the period ending March '20 would sum up Apr '19 to Mar '20. April '20 would sum up May '19 to Apr '20, etc. Each period in the graph would be the trailing 12-month data.


For this, you can create a line/column/area/bar chart with the months as the x-axis, then for the formula use RPSUM or RPAVG, the formula should look like this:
12 indicating the number of periods back
Version history
Last update:
‎10-16-2021 07:20 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: