5 Replies Latest reply on Sep 18, 2018 2:32 PM by Julia.rose

    Dynamic Vertical Reference Line

    Nick Sherriff

      I am attempting to create a dynamic vertical reference line that is dependent upon filtered criteria for a report. The scenario below is hypothetical to help visual what I am trying to build.

       

      Example:

      I have 2 data sources: a transaction level sales report and a list of stores.

      The graph would plot sales data that is filterable at the store level.

      Each store is being redesigned on a different date and when that store is selected from the filter, I'd like to have a vertical line appear at the redesign date to assist with visualizing pre and post-redesign sales.

      The date of the redesign is included on the secondary data source with the store information and there is a unique store ID on both data sources to link them together.

       

      Any assist you can offer would be greatly appreciated.