Hi,
Notice that there is a time worked value in the incident table and also a incident_time_worked.
I'm getting wildly different values when calculating time worked in the incident table vs time worked in the incident_time_worked table for resolved incidents yet they both have the same number of INCs.
They have exactly the same filter:
State(state) != Canceled>Resolved on Last month>Assignment group = X
Incident (time worked)
Count = 97
Sum = 3d 14hr 57min
Incident_Time_Worked
Count = 97
Sum = 21 d 1hr 25min
Does anyone know what is causing the difference? The 'Incident (time worked)' feels like the most suitable value, however, as I'm filtering by assignment group I think the 'Incident_time_worked' would be the most appropriate as it would give me the specific value associated to that team only.
