Simple way to convert decimal number to hh:mm:ss

[JKRAUS81]

In our data, we attempt to get an Average Answer Time from our call data by creating a measure and taking the Total Answer Time in seconds and dividing that time by the Total Calls Answered. The end result gives us a decimal number that in Excel or Tableau we can easily convert into a hh:mm:ss format.

I've attempted to do the following:

Average Call Answer Time = FORMAT(SUM(TotalCallAnswerTime) / SUM(TotalCallsAnswered),"hh:mm:ss")

While this method words for tables and matrix's, but on my graphs I get the following error:

Error Message:
Query (16, 3) The SampleAxisWithLocalMinMax function requires Measure parameter (at argument number 5) to be a numeric column reference from the specified table.

Please assist and thank you in advance!

[Anonymous]

Hi,

Your method seems not working with my sample.

Regarding to the issue of converting seconds into HHMMSS, I suggest to have a look at the article and video：

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
https://www.youtube.com/watch?v=V6GW6Z0-pFo

Best,
Paul

[JKRAUS81]

Thank you, I had already found this article and attempted it but it also ended in a very similar result.

It shows my already aggregated decimal number correctly in the tables and matrix but on graphs the measure won't go into the values field, only the tooltip since it comes out as text format.