topic Re: How to calculate Average Queue Time in DAX Commands and Tips

How to calculate Average Queue Time

Anonymous — Wed, 28 Sep 2022 09:49:17 GMT

How to calculate Average Queue Time

Re: How to calculate Average Queue Time

Anonymous — Wed, 28 Sep 2022 09:50:30 GMT

amitchandak, can you help me out for same

Re: How to calculate Average Queue Time

komald — Wed, 28 Sep 2022 09:57:15 GMT

Anonymous , Try this

create measure,
avg queue time=divide(sum(total queue time) , sum(calls queued))
put this measure in card

or

create calculated column
avg queue time= total queue time / queued calls

Re: How to calculate Average Queue Time

Anonymous — Wed, 28 Sep 2022 09:56:40 GMT

Hi,

Total queue time is in text format so unable to divide with call queued ..

Re: How to calculate Average Queue Time

komald — Wed, 28 Sep 2022 09:59:56 GMT

Anonymous , then use value function

avg queue time= value( total queue time )/ value(queued calls)
try this let me know is this work for u or not.

Re: How to calculate Average Queue Time

Anonymous — Thu, 29 Sep 2022 09:00:35 GMT

Hi,

It's not working ..

Re: How to calculate Average Queue Time

komald — Thu, 29 Sep 2022 09:17:57 GMT

Anonymous , can you please share your dax with error?

Re: How to calculate Average Queue Time

Anonymous — Thu, 29 Sep 2022 11:47:19 GMT

VALUE(SUM('Raw Data'[Total Queue Time])) / SUM('Raw Data'[Calls Queued]))

Re: How to calculate Average Queue Time

komald — Thu, 29 Sep 2022 12:46:54 GMT

Anonymous ,

Re: How to calculate Average Queue Time

Anonymous — Thu, 29 Sep 2022 13:10:58 GMT

let me check

Re: How to calculate Average Queue Time

komald — Fri, 30 Sep 2022 04:15:51 GMT

Anonymous , if i ans your question please mark as a solution. Thanks

Re: How to calculate Average Queue Time

Anonymous — Mon, 03 Oct 2022 08:39:31 GMT

Hi,

Still it's not done , i am sharing some more raw data for more clarity.. can you please check ..

left side is raw data and right side table is output .. i wanted to show same output table..

can you please help me out..

thanks in advanced..

Re: How to calculate Average Queue Time

Anonymous — Mon, 03 Oct 2022 08:49:54 GMT

Raw data

Date	Interval	Calls Queued	Total Queue Time
02-05-2022	02:00-02:30	0	00:00:00
02-05-2022	02:00-02:30	0	00:00:00
02-05-2022	02:00-02:30	0	00:00:00
02-05-2022	02:30-02:60	2	00:01:43
02-05-2022	02:30-02:60	0	00:00:00
02-05-2022	02:30-02:60	1	00:00:43
02-05-2022	02:30-02:60	1	00:02:42
02-05-2022	02:30-02:60	1	00:07:43
02-05-2022	02:30-02:60	0	00:00:00
02-05-2022	02:30-02:60	2	00:02:10
02-05-2022	02:30-02:60	2	00:02:29
02-05-2022	02:30-02:60	0	00:00:00
02-05-2022	05:00-05:30	1	00:05:24
02-05-2022	05:00-05:30	0	00:00:00
02-05-2022	05:00-05:30	2	00:05:55
02-05-2022	05:00-05:30	1	00:00:43
02-05-2022	05:00-05:30	0	00:00:00
02-05-2022	05:00-05:30	1	00:01:36
02-05-2022	05:00-05:30	1	00:00:09
02-05-2022	05:00-05:30	1	00:00:22
02-05-2022	05:30-05:60	1	00:18:25
02-05-2022	05:30-05:60	2	00:09:18
02-05-2022	05:30-05:60	0	00:00:00
02-05-2022	05:30-05:60	1	00:02:53
02-05-2022	05:30-05:60	2	00:07:56
02-05-2022	05:30-05:60	1	00:04:22
02-05-2022	05:30-05:60	1	00:01:01
02-05-2022	05:30-05:60	1	00:02:52
02-05-2022	05:30-05:60	1	00:07:21

Result

Interval	Calls Queued	Total Queue Time	Average Queue Time(Total queued / call queued)
Total	26	1:25:47	0:03:18
02:00-02:30	0	0:00:00	0:00:00
02:30-02:60	9	0:17:30	0:01:57
05:00-05:30	7	0:14:09	0:02:01
05:30-05:60	10	0:54:08	0:05:25

Re: How to calculate Average Queue Time

Anonymous — Tue, 04 Oct 2022 10:44:54 GMT

tamerj1 ,can you please solve this..

Re: How to calculate Average Queue Time

tamerj1 — Tue, 04 Oct 2022 13:02:53 GMT

Hi Anonymous
Please refer to attached sample file with the solution

Average Queue Time = VAR TotalTime = [Queue Time] VAR TotalSeconds = SECOND ( TotalTime ) + MINUTE ( TotalTime ) * 60 + HOUR ( TotalTime ) * 3600 VAR AverageSeconds = DIVIDE ( TotalSeconds, SUM ( 'Table'[Calls Queued] ), 0 ) VAR Hours = FORMAT ( QUOTIENT ( AverageSeconds, 3600 ), "00" ) VAR BalanceSeconds = MOD ( AverageSeconds, 3600 ) VAR Minutes = FORMAT ( QUOTIENT ( BalanceSeconds, 60 ), "00" ) VAR Seconds = FORMAT ( MOD ( BalanceSeconds, 60 ), "00" ) VAR Result = Hours & ":" & Minutes & ":" & Seconds RETURN Result

Re: How to calculate Average Queue Time

Anonymous — Thu, 06 Oct 2022 13:00:49 GMT

Hi ,

I was shared sample data with you, DAX was working fine , but when i am adding 2 months data it is showing wrong, Queue time is showing wrong , it will go >24 hours , for < 24 hr it is working fine.

for > 24 hour queue time what is the solution for that..

Re: How to calculate Average Queue Time

tamerj1 — Thu, 06 Oct 2022 13:23:08 GMT

Hi Anonymous
If you add the month column to the visual it should work fine.

Re: How to calculate Average Queue Time

Anonymous — Thu, 06 Oct 2022 13:55:59 GMT

For interval wise it is showing correct but total is showing incorrect,,

Re: How to calculate Average Queue Time

Anonymous — Fri, 07 Oct 2022 08:03:48 GMT

can you please check ?