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!

Lagged Calculated Measurement?

Comments

  • jharrisjharris LondonSYS_ADMIN IMG42
    edited February 2021
    Hi @JustPivot,

    Time Comparison queries are special in Datorama. They can look for data outside of your filtered date range, and usually come with multiple values and special formatting.

    You can replicate this to an extent, but with some limitations.

    For the use case you described, it sounds like you could use two filtered measurements and a calculated measurement to do this. Use the filtered measurements to do the date filtering, and use the calculated measurement to divide one by the other.

    The main limitation you'll need to be aware of when using this solution is that your query date range will need to include the entirety of the current AND comparison periods, since filtered measurements won't look outside of the query date range.

    Cheers,
    Josh
Sign In or Register to comment.