Static reference line

[dries_clairhout]

Dear community,

For a client of mine we hav this reference line:

=avg(total aggr(sum($(vColli))/$(vDag),Datum, magazijnier))

Now if I Select something, the line adjusts.

But actually it should keep the total average line even when selecting a single person.

Here's a visual of the graph:

Thanks in advance

[agigliotti]

maybe this:

=avg( {1} total aggr(sum($(vColli))/$(vDag),Datum, magazijnier))

I hope it helps.

[sunny_talwar · Accepted solution]

Or this

=Avg(TOTAL {1} Aggr(Sum({1} $(vColli))/$(vDag), Datum, magazijnier))

[amit_gupta]

=avg(  total {1} aggr(sum({1}$(vColli))/$(vDag),Datum, magazijnier))

I think in Variable's expresssion  also, you need to modify:

$(vColli)

$(vDag)

[dries_clairhout]

Gives back a completely different result :s

[dries_clairhout]

Sorry for asking,

modify how exactly?

thanks

[ckarras22]

Amit is correct, what exactly vColli and vDag have as values?

[sunny_talwar]

Would you be able to share a sample or an image to show what your issue is?

[dries_clairhout]

Vcolli is a numeric value, if you have a crate with 10 articles in it, 1 article = 1colli

Vdag is a date (dag = day)