Set up a "work day" unit for a PA Indicator

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-29-2024 04:45 AM - edited ‎02-29-2024 04:46 AM
I have been looking into setting up indicators based on a SLA source.
The SLA data which is collected from my daily job is set up with a work day schedule, mondays-fridays through 8:00 - 16:30. The collection itself is fine and it collects the correct data but I want to visualize it in Analytics hub (and on the widget) in a way that shows it correctly.
OOTB when I set up the indicator with the unit "time" it shows days, minutes and optionally seconds, but it displays one day as 24hrs which makes it really difficult to interpret the actual business elapsed time on our records since we have 8hrs work days.
I can get around this by using the "hours" unit and set up a precision of 2 to get more easily read data directly on the graph but I want to either set it up so that we can see Days, Hours, Minutes but where the "Day" represents our 8hrs work day OR set it up to only show Hours and Minutes.
Does anyone know if I can create a new unit for my use case with either a 8hrs day work week or to only show hours and minutes, or can I create a script which does the calculation for me and is able to visualize it with days, hours and minutes in Analytics Hub?
Thanks for your insights!
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-29-2024 09:23 AM
Hi Hampus, as far as I know you have to use formula indicators for this. I think there are some out of the box, but if not, here's the formula we use.
(([[Catalog Tasks, Closed, Sum of Business Duration]] / (8*60*60*1000)) / [[Catalog Tasks, Closed]])