2 Replies Latest reply on Oct 2, 2017 8:29 AM by Srikanth Namburu

    Week Over Week Dashboard

    Srikanth Namburu

      Hello All,

      I have a question regarding calling a selected value in a quick filter to the calculated filed.

       

      Here is the requirement

      I want to show WoW report something like this (User to pick Week1 vs Week2, I want to use a quick filter instead of Parameter since they are not dynamic)

      Sample.jpg

      My Source Data will only have 3 columns

      Week      Type           Spend

       

      So for the dashboard purpose, I created two Dimensions (for Quick Filters so users can pick, only Single value select)

      • Week1
      • Week2

      Now I am trying to create metrics

      • Week1Spend --> This should be the data for Week1 filter only  --> Question is how do we pass the value selected in Week1 to this and ignore the value selected in Week2 filter
      • Week2Spend --> This should be the data for Week2 filter only  -->Question is how do we pass the value selected in Week2 to this and ignore the value selected in Week1 filter
      • Variance ($) = Week2Spend – Week1Spend

       

      Attached the sample dashboard. Please check and let me know whether it is possible to achieve with quick filters

       

      Thanks