2 Replies Latest reply: Aug 19, 2016 11:35 AM by Kenneth Edwards RSS

    Issue using fields inside set analysis

      I have two fields: "KeyDate" and "Chosen Date".  I am trying to make a chart expression that outputs all data for KeyDate<"Chosen Date".  Basically I'd like the user to select a date in a filter pane (Chosen Date), and the chart output all data from the earliest date up until that point.


      My current chart expression: This doesn't work.  I have tried with quotes, without quotes, and many different syntax options and it outputs nothing.

           Sum({$<[KeyDate] = {'<[Chosen Date]'}>} Usage)


      The same expression works when I input the date num manually.

      Sum({$<[KeyDate] = {'<48462'}>} Usage)

      If anybody could tell me what I'm doing wrong it would be much appreciated.