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.
Thank you all.