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!
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!
Quarter to date this year and last year comparison


in Help Center
Hi All,
Is that possible to calculate percentage difference for this year and last year comparison for QTD, YTD, MTD in Datorama?
Is that possible to calculate percentage difference for this year and last year comparison for QTD, YTD, MTD in Datorama?
Comments
Yes, this is possible!
The approach I would take is to put each measurement in a filtered measurement and then filter it on the time frame desired. Within the filtered measurement, you will see a checkbox for Time Period and the opportunity to filter based on date range. These selections will have QTD and YTD and MTD options.
Then, after the filtered measurements are made, the filtered measurements can be used within a calculated measurement to calculated the percent difference between the two.
I hope this is helpful!
Marissa