0 Replies Latest reply: Mar 22, 2018 5:20 AM by Pol Masanas RSS

    How can I get the latest KPI for a certain indicator?

    Pol Masanas

      Hey all!

       

      I have been trying to get the KPI for a precise indicator. My table looks (similar) to this:

      DatetimeIndicatorValueDate

      201802010000

      I19801/02/2018
      201712310000I21231/12/2017
      201712310000I33531/12/2017
      201712190000I19419/12/2017
      201711090000I110409/11/2017
      201709010000I33301/09/2017
      20170126I23026/01/2017

       

      What i want to get is three different KPIs showing the most recent value (higher datetime) for the indicators, such as

                I1: 98

                I2: 12

                I3: 35

       

      I have tried doing something like Sum( if( Datetime = Max(Datetime), if( Indicator = "I1", Value)))

       

      Any help is much appreciated

       

      Thank you!