I've been playing arround with this chart, in which I now want to create an average line based on the blue and red line. Or on Operator dimension in general. If I would have 3 operators selected, then give the average line of those 3 operators.
I know how to create a straight average line, but I want it to vary with every week. So the average should be based on the expresion.
Should I define this line by adding a new expression? If so how do I do this?
In words, the expression should: Generate a line based on the selected operator AND should match operator O. So if no operator 'O' is selected it just doesn't show a line. If this is possible I would now be able to make different selections for operators in a listbox, while using the same graph which just changes based on the selected operators.
I this case I should make this expression for every operator available, which is ok. Is this possible?