This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
I think you forgot to attach the image. It would be nice to see a sample of the current data and the desired result.