topic Re: Script expression question in Connectivity & Data Prep

Script expression question

HH3571 — Tue, 13 Dec 2022 06:40:09 GMT

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

Re: Script expression question

MayilVahanan — Tue, 13 Dec 2022 07:20:42 GMT

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

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

Re: Script expression question

HH3571 — Tue, 13 Dec 2022 07:39:56 GMT

Thank you sir, worked like a charm!

Best regards

Re: Script expression question

MayilVahanan — Tue, 13 Dec 2022 08:05:24 GMT

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