1 Reply Latest reply on Jul 22, 2016 5:16 PM by swaroop.gantela

    filter line/area charts on some dates while keeping entire date range axis

    jenn.ng

      I have 2 fused area charts below. My aim is to only keep the last 4 data points for the area chart. i.e. only start the area chart on jan 20. I want to keep the entire  predicted line chart from dec 31. How do i write a calculated field for putting into the filter for the area chart?

       

      i have a calculated field like this but it doesnt work and it requires me to manually add in the date. I get an error that i cannot compare date and float.

      if [Week]>1/20/16 then [Upper-int]

      END

       

      Screen Shot 2016-07-21 at 5.11.01 PM.png