Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3002 Topics
C
carlo.ruggi
asked in Process Analysis
Activity Selection in PQL Syntax

Hello, I don`t know what is the correct PQL Syntax for this Activity Selection for my KPI Component option (see screenshot). Thanks in advance for your responses :o)) image.png1061476 22.5 KB

2
C
5 years ago
S
stefan.gross
asked in Data Ingestion & Infrastructure
Getting Difference in consecutive data values in time series data (column chart)

Dear all,I have a time series plot of the automation rate like the following:x- Axis: ROUND_MONTH(EKKO.AEDAT)y-Axis: KPI(Automation Rate) (standard automation rate formula; should work then with any KPI)My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.How to do this in celonis? In the end I want to have a list of KPIs which from design point of view look like the followingIs there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?Thxs & Br,Stefan

2
S
5 years ago

Badge winners

  • Certified to Build Analyses
    ben.lakho11has earned the badge Certified to Build Analyses
  • Certified to Get Data Into Celonis
    ben.lakho11has earned the badge Certified to Get Data Into Celonis
  • Certified to Build Action Flows
    ben.lakho11has earned the badge Certified to Build Action Flows
  • Certified to Build Views
    ben.lakho11has earned the badge Certified to Build Views
  • Certified to Write PQL Queries
    ben.lakho11has earned the badge Certified to Write PQL Queries
Show all badges
Terms & ConditionsCookie settings