is it possible to show Data Visualization in HH:MM:SS format?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2025 06:01 AM
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.
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