Time stamp (month) of a specific activity as a dimension for a column chart

Hello,

I’m only starting to use Celonis, so maybe my question is a super obvious one. But I need to learn somehow:)

I’m working on an O2C process, based on SAP.

I need to create a column chart, where as a dimension I need the month when a specific activity (create delivery) happened. So, not the case creation (VBAK.ERDAT), but the time stamp of the activity “create delivery”.

Can anyone help me to come up with a proper statement for that?

Thanks in advance
Regards,
Masha

Hello Masha,

Great to hear that you are getting started with Celonis!

Please try out the following PQL-statement for the dimension of your column chart:

PU_FIRST(“VBAP”, ROUND_MONTH("_CEL_O2C_ACTIVITIES".“EVENTTIME”), “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘Create Sales Order Item’)

If you want to know more about PU-Functions, I can highly recommend the following guide:

The longest but ultimate guide for being a Pull-Up-Functions expert

Let me know if you have any remaining questions.

Best regards,

Timo

Hello Timo,

thank you very much, although it did not work exactly like this. This statement (also advised by your Data Science team) worked though:

ROUND_MONTH(PU_FIRST(VBAP,"_CEL_O2C_ACTIVITIES".“EVENTTIME”, “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘create delivery’))

I guess the idea is the same. Anyway, thank you!

Regards
Masha