Skip to main content
Question

How to get the correct avg values for following scenario?

  • August 19, 2022
  • 2 replies
  • 2 views
.
Level 2

Hello everyone,

 

the uploaded picture shows my current problem. I need to transform an inputtable to get to the correct avg values as my output.

 

202260819_celonis_right_avg

    2 replies

    .
    Level 11
    • .14600110018
    • Level 11
    • August 23, 2022

    Hi @1460031749,

     

    I would create an help table in transformations that has unique rows (so it deletes the duplicate rows) then create an OLAP table accordingly.

    .
    Level 2
    • .1460057128
    • Author
    • Level 2
    • August 24, 2022

    Hi @1460031749,

     

    I would create an help table in transformations that has unique rows (so it deletes the duplicate rows) then create an OLAP table accordingly.

    Hi,

     

    first of all thanks for the reply.

     

    How can i create a help table? I thought that i need somehow create that table in pql. But i dont know how.

     

    Another question would be where to use that pql-statement? Do i need to put it into the dimensions or the KPI section?

     

    best regards

    Andreas

    Community Code of ConductAccessibility statement