I have event log as
leading_object_id activity_name resource
1 Create Invoice A
1 Approve Invoice Z
2 Create Invoice A
2 Create Invoice B
2 Approve Invoice B
I want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?
VAR_create =
FIRST(
CASE WHEN "ACTIVITY_NAME" = 'Create Invoice' THEN "RESOURCE" END
)
VAR_approve =
FIRST(
CASE WHEN "ACTIVITY_NAME" = 'Approve Invoice' THEN "RESOURCE" END
)
FILTER COUNT_DISTINCT("LEADING_OBJECT_ID")
WHERE VAR_create = VAR_approve
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.