Skip to main content
Question

PQL query (KPI)to get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice

  • May 22, 2025
  • 1 reply
  • 26 views
Sony Shrestha
Level 2
Forum|alt.badge.img

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?

    1 reply

    Rami Agha Kassab
    Level 3

    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
     


    Community Code of ConductAccessibility statement