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?

  • Jul 21, 2023 1:01 PM UTC
  • 2 replies
  • 91 views
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

    Level 2

    SUM

    (

    CASE WHEN _CEL_ACTIVITIES_.USER TYPE = A THEN 1 END

    )

    / COUNT (_CEL_ACTIVITIES_.ACTIVITY_EN)

    Level 1
    • vijay.s25
    • Author
    • Level 1
    • Jul 21, 2023 3:17 PM UTC

    Thank you, Hari

    Community Code of ConductAccessibility statement