10 Replies Latest reply on Jan 5, 2017 9:30 AM by stephen.desmond

    Using Parameter Values to define Date Range shown on Graph

    stephen.desmond

      I'm looking to use the selections on some Parameter values to only show dates greater than a certain range.

       

      I'm trying the following but keep receiving syntax errors:

       

      IF[p.GEO]='UK' AND [p.Product]='DVD' THEN [CALENDAR DATE]>='12/12/2016'

      ELSEIF [p.GEO]='DE' AND [p.Product]='BluRay' THEN [Calendar Day]>='12/25/2016'

      ELSE NULL

      END

       

      I wish for the calculation to only show sales beyond these dates once these options are selected. Any ideas what I need to do to get that working?

       

      Thanks