Skip to main content
Question

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

  • May 28, 2020
  • 2 replies
  • 9 views
M
Level 5
Hello, Im only starting to use Celonis, so maybe my question is a super obvious one. But I need to learn somehow:) Im 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

2 replies

C
Level 0
  • celonis.ds_se
  • Level 0
  • 68 replies
  • June 3, 2020
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
M
Level 5
  • masha.galit
  • Author
  • Level 5
  • 14 replies
  • June 3, 2020
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


Community Code of ConductAccessibility statement