Hello everyone,
I am facing an issue while working with Celonis Studio. I have created a variable as follows:
YEAR(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1)) ||MONTH(ADD_MONTHS(ROUND_MONTH(MAX("view_meviy"."timestamp")), -1))
Now, I want this variable to respond to the date filter in my report. Specifically, I want the variable to update its value to reflect the previous month based on the selected date in the filter.
I would appreciate any assistance and guidance from the community on how to properly set this up.