Hi everyone,
I want to add a PQL filter/ statement to my dashboard. I have an OLAP table with the results of multiple IBAN checks that runs every day (so the results are double, but with different dates). I want to add a filter to show the results only once with the newest date.
If you can provide some of the PQL ( dimension and KPI) that would be helpful.
Assuming the date is the only different, then either you can use regular aggregation or Pull Up function
LAST ( table.column , ORDER BY table.date_column ASC )
and Pull Up function : https://docs.celonis.com/en/pull-up-aggregation.html
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
