I have a pivot table based on weekday and description that returns an average time. For instance process A runs an average of 12:00 hours at day 1 (as it may run n number oftimes). The total column in Qlikview returns the average time for each description but ignoring the weekday.
My problem is that I want to color cells that are below the weekly average. So I need an expression that computes the average runtime for each process but ignoring the week dimension.
avg(total Processtime) will return the average over the whole set. avg({<weekday=,>} total Processtime) will only ignore the weekday SELECTION but I need to ignore the weekday dimension altogether.
Please help, this seems relatively straightforward but I can't solve it. I've added a screenshot as, unfortunately, I can't share the QV app.
All I need is an avg(processtime) but over dimension 'description'. How to do this?
