Skip to main content
Question

Can someone please help me with the Automation rate PQL formula, when we have the User type as A and B?

  • July 21, 2023
  • 2 replies
  • 9 views
V
Level 1
Can someone please help me with the Automation rate PQL formula, when we have the User type as A and B?

    2 replies

    H
    Level 2

    SUM

    (

    CASE WHEN _CEL_ACTIVITIES_.USER TYPE = A THEN 1 END

    )

    / COUNT (_CEL_ACTIVITIES_.ACTIVITY_EN)

    V
    Level 1
    • vijay.s25
    • Author
    • Level 1
    • July 21, 2023

    Thank you, Hari

    Community Code of ConductAccessibility statement