1 Reply Latest reply on Oct 18, 2018 11:32 AM by Daniel Lawrence

    LOD to show YOY value in Tooltip?

    Daniel Lawrence

      Hi All,

       

        I am looking to have a basic Line graph by continuous date (in weekly format) vs revenue but I want to put the YOY Revenue Value in the tooltip.  So for the week ending Saturday 9/8/2018, it would display the normal weekly aggregate for 9/2/2018 - 9/8/2018 on the line graph but I want to have the value for the aggregate Revenue from 9/3/2017 - 9/9/2017 as that is the corresponding date range from 2018 off by one day.  I am not sure how to do this with LODs because it gets tricky with the dates being off by one.  Does anyone have any experience with this or ideas?

       

      Thank you!