I think it is just PQL

TO_STRING(ADD_MONTHS(TODAY(),-1), FORMAT ('%Y-%m')) for the dimension label

or something like that

check

https://docs.celonis.com/en/to_string.html

https://docs.celonis.com/en/add_months.html

and for the KPI do a COUNT(DISTINCT CASE WHEN ROUND_MONTH(dateevent) = ROUNDMONTH(ADD_MONTHS(TODAY(),-1)) THEN CASE_KEY

ELSE NULL

END)

HTH

Hi Guillermo,

thank you for your answer.

This kind of logic I've already tried. But when I enter this Code as my column Name it is just saved as string. So that means that the code will be printed, but not the result (The resulting month).

I think some characters and brackets are required, like when using a variable (<%= ... %>). But I don't know which one.

Create a Variable type Static

put it in the label of the KPI

HTH

Thank you very much, this is really good to know! :)

But does it also work for Knowledge Models and Views. So when I want to use a KPI within a Table?

In theory the KM variables can be used in Views, like analysis variables in analysis... but not an expert there...

I tried different options ( View variable/KM Variable/ Global Varible) in views but no luck, please update here if you found something :)

Hi, I've also tried several things, but nothing worked. But when I find something, I will send it to you :)

Hello Celopeers colleagues,

I am working on a tracking table use case for which I require exactly the same - having dynamic column names for month-1, month-2, etc.

The View variable option does not work...as you already mentioned above.

Did you maybe find some good workaround in the meantime?

Thank you for any ideas!

Regards

Jan