2 Replies Latest reply on Sep 14, 2016 12:57 PM by Chris Edwards

    How to create multiple dynamic reference lines for quick filter input

    Chris Edwards

      I have trended data in a line chart and am wanting to add vertical, dynamic reference lines. The trend line can be filtered by state and the reference lines need to change with each state's selection. I have figured out how to get one reference line to show up by setting a parameter equal to the week number where it should be. I then created a calculated field as follows:

       

      CASE MIN([State Code])

      WHEN "CA" THEN ([CA2])

      WHEN "CA" THEN ([CA1])

      END

       

      Obviously this is not working because it can't execute both "When" statements for the same input. Any help would be appreciated.