Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am having trouble finding an Average of a time field that has multiple frequencies.
The attached image shows the field 'Duration_of_Outage' in minutes and the number of incidents that have occurred in that time band.
I need to calculate an average of: 'Duration_of_Outage', but I am not able to sum the field, cos the frequency of each incident has to be included as well.
I tried this expression, but its giving an error: Avg(aggr(Count(incident_distinct_number), Month, Duration_of_Outage)
Could someone please advise if this is the correct expression and is there any other way to achieve the desired result.
Regards,
Akbar
Hi @AkbarShaikh
I think you forgot to attach the image. It would be nice to see a sample of the current data and the desired result.
Regards,
Mauritz