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
  • 151 views

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

2 replies

  • Jul 21, 2023 2:04 PM UTC

SUM

(

CASE WHEN _CEL_ACTIVITIES_.USER TYPE = A THEN 1 END

)

/ COUNT (_CEL_ACTIVITIES_.ACTIVITY_EN)


  • Jul 21, 2023 3:17 PM UTC

Thank you, Hari