Line Chart - Add Mean and Upper/Lower Control Limits

[jerryr125]

Hi - I have a line chart :

Dimension : Date

Measure : sum(Amount)

I would like to add the mean and potentially the upper/lower control limits.

Any thoughts/examples ? Jerry

[jerryr125]

Any thoughts on this question? 

What if I try this :

Of the values selected, what if I wish to display the mean (average) line?

So for example, the user selects a date range and a category - for that selection criteria it displays an average line on the line chart .

Thoughts ? jerry

[JordyWegman]

Hi Jerry,

Use the following formulas:

Mean: Avg(Amount)

Lower: Min(Amount)

Upper: Max(Amount)

Jordy

Climber

[jerryr125 · Accepted solution]

Hi - I added formula reference lines -worked!