Show the latest Date in the KPI

[GaryChin]

Hi All,

I want to show the date on the Second KPI which the expression is:

FirstSortedValue({<measure_point={'AQI'}>}measure_time,-measure_time), but it show not in Date format

 

The date get in the field 

Any help would be very appreciated.

[jaibau1993 · Accepted solution]

Hi!

You have to properly format the expression.

By the way, I think you can use  

Max({<measure_point={'AQI'}>} measure_time)

as expression instead of that 'FirstSortedValue'. It should do the same thing but I think it is conceptually simpler.

Regards,

Jaime.