Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @manoj_0911 ,
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.
You can also make suggestions here to help Desktop do a better job.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution 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. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Could you please attach here the workbook you used for reference?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |