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.
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.