Skip to main content
Solved

How to find number of rework activities with PQL?

  • March 16, 2023
  • 3 replies
  • 72 views
Z
Level 8
How to find number of rework activities with PQL?

Best answer by abhishek.chatu14

You can use the following to calculate the rework for a certain activity

CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A')

 

Taking SUM for the same would give you number of rework activities for all cases

 

SUM(CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A'))

    3 replies

    abhishek.chatu14
    Level 11
    Forum|alt.badge.img+4

    You can use the following to calculate the rework for a certain activity

    CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A')

     

    Taking SUM for the same would give you number of rework activities for all cases

     

    SUM(CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A'))

    G
    Level 12

    You can use the following to calculate the rework for a certain activity

    CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A')

     

    Taking SUM for the same would give you number of rework activities for all cases

     

    SUM(CALC_REWORK( ACTIVITY_TABLE.ACTIVITY = 'Activity A'))

    I wonder why they call it "CALC_REWORK" when it returns the total number of activities per case.

     

    Of course if you filter per a specific activity, then you will get the rework, but... still

     

    I use more often INDEX_ACTIVITY_TYPE when returns more than 1

     

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • March 18, 2023

    I wonder why they call it "CALC_REWORK" when it returns the total number of activities per case.

     

    Of course if you filter per a specific activity, then you will get the rework, but... still

     

    I use more often INDEX_ACTIVITY_TYPE when returns more than 1

     

    because, if an activity occurs more than 1 time in a case this is rework.

    Community Code of ConductAccessibility statement