Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to create a metric-based dynamic tolerance band

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
Comments
-
0
-
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….
2 -
@Avinash Krishnaram-Oracle Very good idea!
1 -
@Abhinav Chaurasia-Oracle FYI - good enhancement to the CF framework.
1 -
Good enhancement request
0