Skip to main content
Question

Hello Celopeers, I'd like to group activities by user name, event time, and activity name before counting them.

  • May 22, 2023
  • 2 replies
  • 3 views
A
Level 1

I'd like to better understand the actual manual work involved by executing a certain activity. In my company, there are activities that are executed as "batch jobs". This means that we can execute the same activity across several line items. In this case, even though it only required one manual execution, it's counted as one across several line items adding up to several "manual" activities. To find a better estimate of the actual manual effort for each activity, I'd like to group them by user name, event time, and activity name.

 

Can anyone help me crack this nut?

 

Thank you in advance for your help!

    2 replies

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

    You can try something like this

     

    COUNT(DISTINCT CASE WHEN CONDITION FOR MANUAL WORK THEN user name||event time||activity name END )

     

    This will give you a distinct value for the grouping of user name, event time, and activity name.

    A
    Level 1
    • andras.perje
    • Author
    • Level 1
    • May 25, 2023

    You can try something like this

     

    COUNT(DISTINCT CASE WHEN CONDITION FOR MANUAL WORK THEN user name||event time||activity name END )

     

    This will give you a distinct value for the grouping of user name, event time, and activity name.

    Thank you Abnishek!

    Community Code of ConductAccessibility statement