is it possible to show Data Visualization in HH:MM:SS format?

NiranjanP
Tera Contributor

Hi,
I'm working on a Requirement: To show First Response Time in "HH:MM:SS" format in Data visualization using Formula Indicator "Case Average Response Time" (OOB) as a Data source.
Formula : [[Summed duration of FirstResponseTime]]/[[Number of Responded Cases]]

Screenshot show the PA script used for "Summed duration of FirstResponseTime", Unit is hours and the Output data is showing in hours.

I Appreciate any suggestions on how to achieve this.

NiranjanP_0-1749474066389.png

var diff=function(x,y){return y.dateNumericValue() - x.dateNumericValue();};
var hours=function(x,y){return diff(x,y)/(60*60*1000);};
hours(current.opened_at, current.first_response_time);
0 REPLIES 0