Show Range
Last updated
Last updated
The Range feature enables you to show additional range information on a chart. It is available in Line and Scatter (No Aggregation) charts.
You can set up the range from the Range Dialog. You can find the Range Dialog in the Y-Axis menu dropdown.
There are 2 range types available.
Confidence Interval
Column
Specific Value
The Confidence Interval option calculates confidence interval ranges from data and shows them automatically on a chart. You can show confidence interval ranges by selecting the "Confidence Interval" from the Range Type menu in the Range Setting Dialog.
There are the following options available for Range Function.
90% Condfidence Interval
95% Condfidence Interval
99% Condfidence Interval
Standard Error
Note that Confidence Interval is available only in Line chart, and is available for Mean, % of TRUE, and % of FALSE functions without Window Calculation being applied on Y-Axis.
If you already have columns for upper and lower limit values for the values on Y-Axis, you can show them as ranges in the same chart.
You can select "Custom" from the Range Type menu and assign columns for Upper Limit values and Lower Limit values.
Columns will be automatically picked and assigned for your convenience if you have one of the following column pairs in the same data frame.
(Y-Axis Column Name)_high and (Y-Axis Column Name)_low
(Y-Axis Column Name).high and (Y-Axis Column Name).low
(Y-Axis Column Name)_upper and (Y-Axis Column Name)_lower
(Y-Axis Column Name).upper and (Y-Axis Column Name).lower
(Y-Axis Column Name)_higher and (Y-Axis Column Name)_lower
(Y-Axis Column Name).higher and (Y-Axis Column Name).lower
conf_high and conf_low
conf.high and conf.low
You can specify the range by setting the upper and lower value manually.
The following range types are available in Line chart.
Confidence Interval
Custom
In Line chart, ranges will be displayed as range bands like the following.
The following range types are available in Scatter (No Aggregation) Chart
Custom
In Scatter (No Aggregation) chart, ranges will be displayed as error bars like the following.
You can optionally set the error bar width in Range Dialog. The default width is 4 in pixel.
