cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emmanuelkamara1
Helper I
Helper I

TIME AGGREGATION

Hi all, I am struggling to do aggregation on ‘time data-type’. I want to compute the average handling time per customer care agent which is (total sum of talking time divided by the sum of ‘answered calls’). I have created a measure that calculates the sum of talking time: total_talking = SUM(CALLLOG[Talking]) and the sum of all calls with status (answered): number_of_calls = CALCULATE(COUNTAX(CALLLOG, CALLLOG[Status.]="1")). To have the Average handling time, I created a measure that divides both measures above: Aht = DIVIDE([total_talking], [no_answered_calls]). However, the result that I am getting looks strange (0.00) for all dates filtration.

 

 

emmanuelkamara1_0-1600687015188.png

NB: I HAVE (ANSWERED STATUS TOO) 

2 REPLIES 2
amitchandak
Super User
Super User

@emmanuelkamara1 , Are you trying to add time ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

If you are trying to add time then

Please refer this :https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Thanks @amitchandak , find below a snapshot of the data set and the resulting output after implementing the formulas I wrote above.

 

 

emmanuelkamara1_0-1600693840851.png

 

 

 

 

 

emmanuelkamara1_1-1600693840855.png

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!