Getting an "Average" Line in Diagram

[#1]

Hello,

I have the following situation:

Dimensions:

- Date

- Supportuser

Formula:

- count(DISTINCT tickets)

Perfect for a stock quotation per "Supportuser".

Now i want an extra line for the "average" of tickets per date.

If i make it with an extra formula like this:

- count(DISTINCT tickets)/GetSelectedCount(Supportuser)

... the diagram "looses" the second Dimension.

Is this even possible to create an extra line for the average of tickets, but with maintaining the second dimension?

Regards

Michael

[#2]

Try adding the average line in using your formula but placing it in the Reference Lines section of the presentation tab.

[Anonymous]

Do you mean you want to add one line, in addition to the existing secondary dimension lines, that will move up and down across the months.

I have not been able to achieve this, either by adding a second expression or a reference line.

Jonathan

[#4]

Didtn´t work .

So it´s not possible?

[Anonymous]

You could try to do it using QlikViews association between fields.

For instance, you are using a SupportUser field to which you add another value for 'AllSupportUsers'. If each time an association is created between your transaction data and a SupportUser, you also create an association to the new 'AllSupportUsers' value too.

In this way, if you include SupportUsers as your secondary dimension you could chart the average of all Support Users individually, as well as the average of the AllSupportUsers value too.

This might work.

Jonathan