Ability to create a metric-based dynamic tolerance band

R Stonaker

We have a business requirement to produce a chart which includes a +/- 10% tolerance band around a metric that is depicted by a line on a graph. I see there are some reference line options under Statistics already but no options to base the band on the individual data points for a metric.

For example, if the metric has monthly values of:

Month 1 = 100

Month 2 = 90

Month 3 = 110

The +/- 10% tolerance band would cover:

Month 1 = 90-110 would be shaded

Month 2 = 81-99 would be shaded

Month 3 = 99-121 would be shaded

User_7VF4L

M.K.Mori

A generic solution might plot a tolerance band on two separate data series. E.g., low = (value - value*0.1) and high = (value + value*0.1) to produce the symmetrical +/-10% case. This would permit asymmetrical bands and support more complex calcs as well….

Benjamin Arnulf-Oracle

@Avinash Krishnaram-Oracle Very good idea!

Avinash Krishnaram-Oracle

@Abhinav Chaurasia-Oracle FYI - good enhancement to the CF framework.

User_437T6

Good enhancement request