Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
AkbarShaikh
Contributor III
Contributor III

How to calculate Average of time field having multiple frequency

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

Labels (3)
1 Reply
Mauritz_SA
Partner
Partner

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