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

polmasanas — Thu, 22 Mar 2018 09:20:24 GMT

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!

topic How can I get the latest KPI for a certain indicator? in App Development