Skip to main content

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.

Be the first to reply!

Reply