topic Re: Line Chart - Add Mean and Upper/Lower Control Limits in App Development

Line Chart - Add Mean and Upper/Lower Control Limits

jerryr125 — Tue, 11 Jun 2019 11:09:31 GMT

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 — Wed, 12 Jun 2019 11:51:15 GMT

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 — Wed, 12 Jun 2019 12:42:44 GMT

Hi Jerry,

Use the following formulas:

Mean: Avg(Amount)

Lower: Min(Amount)

Upper: Max(Amount)

Jordy

Climber

jerryr125 — Wed, 12 Jun 2019 14:09:28 GMT

Hi - I added formula reference lines -worked!