Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

Function Focus: Creating Cumulative Graphs with Calculated Measurements

Have you ever wanted to display cumulative graphs in Datorama? There are so many functions you can use in calculated measurements to help you manipulate the data you are using within Datorama. We are going to focus on one specific function in the post: ACC_SUM

The ACC_SUM function enables you to calculate the accumulating sum for a given metric. You do not need to state the granularity or sort order to use it. This is the basis of creating cumulative graphs in Datorama.

In the below example, we are going to create a graph showing the accumulated impressions over a time period in two easy steps.

1. Create a calculated measurement for you cumulative impressions, using the ACC_SUM function.


2. Create your desired widget with the desired Date dimension and the new calculated measurement, Cumulative Impressions. I would recommend using a line to display your cumulative value - this can be done on a lines widget or in a bars widget, if you want to show it alongside your daily impressions values.

Tip: To add a line onto a bars widget, select Line in the display option under the desired measurement



The below widget demonstrates this use case - tracking cumulative impressions against the planned impressions.


To find out more about the functions available in calculated measurements, here is the knowledge base article:
https://support.datorama.com/en/support/solutions/articles/4000085191-calculated-measurement-functions
Sign In or Register to comment.