11 Replies Latest reply on Feb 15, 2020 7:53 AM by Matt DiPippa

    Comparing Multiple R12 Based on Single Date (Today)

    Matt DiPippa

      Hello,

       

      I am relatively new to Tableau and am unable to share my data set, but i am thinking this can be answered using Superstore data..

       

      I am trying to calculate CAGR over five rolling 12 month periods based on today, so this needs to be dynamic.

       

      I am struggling with how to setup the R12 "buckets" data if you will. For example, I want the most recent R12 data (period 1) to be today +364 days. The second most recent (period 2), days 366-731, and so on and so forth to period 5.

       

      Is there some sort of LoD calc that can get me [measure] data for these five periods? I think there is significant Date logic that needs to be distilled that is holding me back.

       

      Anyone up for the challenge?

       

      Date Column Name: Order Date

      Measure: Sales

       

      Thanks,

       

      MD