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!

Calculated Measurement - Month over Month

Comments

  • Hi @jfb ,

    Thank you for your question.

    I am afraid it will not be possible to create a calculated measurement to show percent MoM variation with just the original measurement. You will need to create an additional data stream.

    1) Export the Monthly data with Month dimension, Main Entity Key (i.e. Media Buy Key for the Ads bucket), and the measurement you want to use.

    2) Upload that Report to a new data stream and map:
    Day = DATEADD('m',1,csv['Month'])
    Main Entity Key
    and the measurement to a custom measurement

    This data stream will upload the original measurement, but 1 month into the future. Then you can create a calculated measurement with the original measurement and the new measurement in order to calculate the change.

    Let me know if you need further assistance :)
Sign In or Register to comment.