Working out the average time for a specific code

[#1]

I have a table that looks like this:

What I want to do is add another column that shows the average number of minutes spent for all calls for the problem code that the call is linked to. Can anyone suggest how I would go about working it out? I'm not sure how I would write an expression to capture the sum of minutes spent for the specific problem code.

[Jason_Michaelides · Accepted solution]

Add an expression:

Avg(TOTAL <[Problem Code]> [Minutes Spent])

Hope this helps,

Jason

[#3]

Awesome - thanks a lot. Qlikview is pretty amazing.

[Jason_Michaelides]

That it is