Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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