3 Replies Latest reply on Jun 19, 2018 8:34 AM by Ken Flerlage

    Changing x axis (time) based on filter

    Tim Cady

      Hi all,

       

      Could use some help with an obstacle I'm facing.

       

      I have a time series analysis I want to change the aggregation of based on user selection. To execute this, I created the following parameter. The problem is that I also have a Relative Date filter and it functions independently from the the parameter. Is there a way to connect the parameter to the date filter so the aggregation matches the data filtered in/out.

       

      CASE [Parameter 1]

      WHEN 'Year' THEN DATEPART('year',[Date])

      WHEN 'Quarter' THEN DATEPART('quarter',[Date])

      WHEN 'Month' THEN DATEPART('month',[Date])

      END

       

      I've attached a Superstore example for reference.

       

      Thank you.