Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
If you want to do in front end [KPI Object], then try like below
Sum({<ROW_ID = {$(=MAX(ROW_ID))}>} VOLUMES)
Hi
If you want to do in front end [KPI Object], then try like below
Sum({<ROW_ID = {$(=MAX(ROW_ID))}>} VOLUMES)
Thank you sir, worked like a charm!
Best regards
H
Hi
Happy to hear that, Please close the thread by marking correct answer & give likes if you like it.