I could use some help with the best way to visualize renewal data, such as renewals rate over by quarter/month. I currently have the ability to create widgets in dashboards for a number of different fields:
- sum of initial ARR (total up for renewal this quarter)
- sum of renewed ARR
- sum of churned ARR
- sum of remaining ARR up for renewal
Since these require different filters, they are currently all different reports, which is fine when wanting to view things based on widgets. Our overall goal would be to store this data in one custom MDA object so that I can visualize out of the total up for renewal dollars, what % is churned, what is renewed, what is remaining up for renewal. I am attempting to use rules to load the sum of these data points into a custom field, but am not sure how to group by date.
Best answer by john_apple
If you use a Group By on the report and select a Date field that will allow you the additional option of doing a summary by day, week, month, quarter, fiscal quarter, year, or fy. We’re you looking to have a stacked column by quarter or something else?