Hey all!
I have been trying to get the KPI for a precise indicator. My table looks (similar) to this:
Datetime | Indicator | Value | Date |
---|
201802010000 | I1 | 98 | 01/02/2018 |
201712310000 | I2 | 12 | 31/12/2017 |
201712310000 | I3 | 35 | 31/12/2017 |
201712190000 | I1 | 94 | 19/12/2017 |
201711090000 | I1 | 104 | 09/11/2017 |
201709010000 | I3 | 33 | 01/09/2017 |
20170126 | I2 | 30 | 26/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!