We can't convert the avg number of seconds to time format (we tried various solutions from this forum)

[RoyBatty]

Hi,

We have a measure that calculates the average value in seconds:

Avg([ticket_stats.first_agent_response_time])

(`ticket_stats.first_agent_response_time` is the number of seconds, and in Data model viewer it shows that it is $numberic $integer)

The result is values ​​like:

• 14,186.87
• 53,156.22
• 61,339.88
• 29,087.98
• 8,725.44

We want to present those values ​​(which are in seconds) in a time format, D hh:mm:ss or maybe just hh:mm:ss (we are still not sure which format will suit us better).

However, the problem is that we don't know how to do it. We searched the forum, we found many posts/solutions, but none of them work in our case. For example:

=Interval(Avg([ticket_stats.first_agent_response_time])/86400,'D hh:mm:ss')

Result:

Also, the other solutions didn't work either:

=Interval(Avg([ticket_stats.first_agent_response_time])/86400, 'hh:mm:ss') 

=Interval(Interval#(ceil(Avg([ticket_stats.first_agent_response_time])),'s'), 'hh:mm:ss') 

=time(Avg([ticket_stats.first_agent_response_time])/3600/24, 'hh:mm:ss')

=interval(timestamp#(ceil(Avg([ticket_stats.first_agent_response_time])), 's'), 'hh:mm:ss')

=Time(Avg([ticket_stats.first_agent_response_time])/24/60/60,'hh:mm:ss')

Do you have any suggestions?

[Lisa_P]

When I use the number it works:

[RoyBatty]

@Lisa_P 

[RoyBatty · Accepted solution]

The problem is that "Number" was selected for Number formatting 😑. Now, when I selected "Auto" - everything is ok.

=Interval(Avg([ticket_stats.first_agent_response_time])/86400,'hh:mm:ss')