How to find the difference between two date time columns and show the result as HH:MM:SS in a bar ch

Question

How to find the difference between two date time columns and show the result as HH:MM:SS in a bar chart (Attached Requirement)

REQUIREMENT 1 : TIME IN THE QUEUE FOR EACH CALL

REQUIREMENT 2 : MAXIMUM WAIT TIME FOR EACH QUEUE

REQUIREMENT 3 : AVERAGE WAITING TIME FOR EACH QUEUE

REQUIREMENT 4 : TOTAL WAIT TIME FOR EACH QUEUE

WAITING TIME FORMULA:

DATASET:

ConversationId,QueueName,SkillList,StartDate
a8115f14-c64f-49a7-b695-b3dd601be5e1,ReportingIndia,reporting_skill_2,23-11-2022 17:05:55
db8c5cd9-bc61-4ae1-a47e-7ef9fdf58275,Pru_Annuities,reporting_skill_1,23-11-2022 17:10:06
188ddb5d-2184-4042-bcf9-5a118bdd24c5,PRU_Annuities_Sales,reporting_skill_2,23-11-2022 17:15:06
0e1397d1-fdce-49af-b705-be559107ae75,PRU_Annuities_RegionalMarket,reporting_skill_3,23-11-2022 17:20:06
ea34c3f3-70cf-4ecb-8beb-0e605546573d,QSSA,reporting_skill_4,23-11-2022 17:25:06
367cb474-61a5-4b05-8d54-df27c3d5a773,QSSA,reporting_skill_5,23-11-2022 17:30:06
7d105385-c37c-476c-9e70-ffa13b124587,QSSA,reporting_skill_6,23-11-2022 17:35:06
c6ee63a8-6f1d-4c93-bf60-93384dd754b9,ReportingIndia,reporting_skill_7,23-11-2022 17:40:06
6008b347-6abd-4df9-8f65-e9dbd6aecd84,ReportingIndia,reporting_skill_8,23-11-2022 17:45:05
c418edcf-80ec-4aef-9a53-b274ade67f75,ReportingIndia,reporting_skill_9,23-11-2022 17:50:02

anonymous · Answer

Hi&nbsp;manoj_0911&nbsp;,There was a little bit of difficulty. There are ways to convert the final calculation to a scalar of text type(h:mm:ss), but after testing it doesn't display properly when used as a value for a bar chart. My suggestion is to use DATEDIFF() to convert the time to decimal time (like14.56 hours) if you want.
&nbsp;
You can also make suggestions here to help Desktop do a better job.
Ideas
&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum

manoj_0911 · Answer

Could you please attach here the workbook you used for reference?

Forum Discussion

How to find the difference between two date time columns and show the result as HH:MM:SS in a bar ch

2 Replies