Forum Discussion

odzelashvili1's avatar
odzelashvili1
Icon for Helper I rankHelper I
5 years ago

Calculate individual actions time duration for one unique queue

Hello PBI community 🙌

 

I'm building queue management report for my organization and I have some issues 🙂

 

My table looks like this:

where visit_key is unique queue number, and IDs are action IDs, which take this queue N.

 

I have calculated time from first entry (VISIT_CREATE) to first call and from entry to last action (VISIT_NOSHOW), I know that this queue was transferd 4 times and accordingly was called 4 times (5 in total, first in registration and 4 others).

 

What is my issue, I want to calculate all time duration from VISIT_TRANSFER_TO_QUEUE to VISIT_CALL.

 

any ideas? or do I explained my wish clearly?

 

thanks in advance 🙂

Need Help

4 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi odzelashvili1 

    you can try this

    Diff_minute =
IF (
    MIN ( 'Table'[Column4] ) = "VISIT_TRANSFER_TO_QUEUE",
    DATEDIFF (
        MIN ( 'Table'[Column3] ),
        CALCULATE (
            MIN ( 'Table'[Column3] ),
            FILTER (
                ALL ( 'Table' ),
                'Table'[Column4] = "VISIT_CALL"
                    && 'Table'[Column3] > MIN ( 'Table'[Column3] )
            )
        ),
        MINUTE
    )
)

    result

     

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi odzelashvili1 

    Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
    really appreciate!
    Any question, please let me know. Looking forward to receiving your reply.


    Best Regards,
    Community Support Team _Tang

    • odzelashvili1's avatar
      odzelashvili1
      Icon for Helper I rankHelper I
      5 years ago

      Sorry for so late answer, 

       

      it doesnt worked 😞 and it is no longer important.

       

      anyway, thanks for taking your time for my task 🙂