11 Replies Latest reply: Aug 29, 2017 2:19 PM by Rob Wunderlich RSS

    KPI - Displaying a single static value based on a date

    Michael Porco

      Hello,

       

      I'm trying to display the latest value from a field in a KPI.

       

      vMaxDate is declared as a variable and has the latest date from the table of information.

       

      'Date' and 'SampleField' are both fields within my data set.

       

      I'm trying to use the following expression within my KPI and it doesn't work.

       

      MAX({1<Date={vMaxDate}>} SampleField)

       

      It won't display anything. I tried copying and pasting the exact same expression into a table for debugging purposes but I receive an 'invalid dimension' error.

       

      I wouldn't mind understanding how to display the latest value (based on date) on app startup and then the KPI displayed value being overwritten once a selection is made. I'm not sure how to approach that.

       

      Thanks.