How to calculate Average of time field having multiple frequency

AkbarShaikh — Sat, 16 Nov 2024 19:11:36 GMT

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

Re: How to calculate Average of time field having multiple frequency

Mauritz_SA — Mon, 03 Feb 2020 11:09:35 GMT

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

topic Re: How to calculate Average of time field having multiple frequency in App Development

How to calculate Average of time field having multiple frequency

Re: How to calculate Average of time field having multiple frequency