Skip to main content

Hello all.

 

I tried to filter the column "Year-Month" but the problem is that there is a warning. I also checked if there is an error in my PQL coding, so I copied the code to the process engine and checked all the columns below separately. No errors. 

 

Anyone has an idea how to solve this?

 

The code for year-month is:

 

YEAR(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) || '-' || MONTH(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE))

 

Another problem is that if I use "year-month" as a treshold my signals don't show. If i take the filter off, I see all signals.

image 

Thank you all.

Hi @1460047082,

 

Not sure why this error is popping up. Maybe you could try to use another variant of your code:

TO_STRING (MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE), FORMAT ('%Y-%m'))

 

See TO_STRING (celonis.com) for more context.

 

Cheers,

Jan-peter

 


Reply