Script expression question

[HH3571]

Hello, 

i have a column (VOLUMES). I want to select the latest data point in it, in a KPI chart. As a reference i have a column (ROW_ID), so the MAX(ROW_ID) should be equal to the latest (VOLUME) data point row wise.

If it were in SQL i would write something like:

SELECT VOLUMES FROM table

WHERE ROW_ID = MAX(ROW_ID)

How do i do this in the script editor?

Best regards

H

[MayilVahanan · Accepted solution]

Hi

If you want to do in front end [KPI Object], then try like below

Sum({<ROW_ID = {$(=MAX(ROW_ID))}>} VOLUMES)

[HH3571]

Thank you sir, worked like a charm!

Best regards

H

[MayilVahanan]

Hi

Happy to hear that, Please close the thread by marking correct answer & give likes if you like it.