Calculation Type - You can select an error bar calculation type from the following options. The default is Mean
.
Mean - Average based error bar chart.
Ratio (%) - Ratio based error bar chart based on the count of values.
Marker - You can select a marker type from the following options. The default is Bar
.
Bar - Suitable for comparing actual values and error bar ranges.
Circle - Suitable for comparing error bar ranges.
X-Axis - Assign a column you want to show at X-Axis. If it's a Date / Time column assigned, you can select the aggregation level such as Month
, Week
, Day
, etc. If you assign a Number column, you can choose either As Number
to treat values as continuous values or As Text
to treat values as categorical values.
Y-Axis - Assign a column you want to show at Y-Axis.
If the calculation type is Mean
, you can only choose Average
for the column function.
If the calculation type is Ratio (%)
, you can only choose one of the count-based functions following for the column function.
Count
Unique Count
Number of TRUE (logical only)
Number of FALSE (logical only)
Range Type - You can select an error bar range type from the following options. The default is Standard Error
.
Standard Error
95% Confidence Interval
99% Confidence Interval
1 Standard Deviation
2 Standard Deviation
3 Standard Deviation
IQR
Color - Take a look at Color section for more details.
Sort By - Assign a column to use for Sorting the X-Axis values. The default is based on either the alphabetic order or the factor level order for Factor type columns.
Repeat By - You can assign a column to repeat the chart for each of its values. Take a look at Repeat By section for more details.
Orientation - You can choose a chart orientation. Either 'Vertical' or 'Horizontal'.
Standard Error
​
95% Confidence Interval
​
99% Confidence Interval
​
Standard Error
​
95% Confidence Interval
​
99% Confidence Interval
​
Take a look at Reference Line section for more details.
You can change the color of the specific markers such as bars, lines or circles that you pick to stand out from others. See Highlight for the detail.
You can categorize numeric values inside the chart. See Category(Binning) for the detail.
You can use Limit Values to filter the categories by the aggregated values. See Limit Values for the detail.
If the calculation type is Ratio (%)
, you can set how to group by for the percentage calculation in Group Setting dialog. You can reach the Group Setting dialog from the Y Axis menu. Following group by options are available. The default value is X Axis
.
X Axis - Calculate the ratio for each X Axis data point. The total percentages on each X value will be 100%. For example, the total percentatge of all the color bars on Sun
becomes 100%.
​​
Color - Calculate the ratio for each color value. The total percentage on each color value will be 100%. For example, total percentatge of all the blue bars becomes 100%.
​​
All - Calculate the ratio based on all data point. The total percentage of all the data point will be 100%.
​​
You can use the Missing Value Handling feature to control missing values. See Missing Value Handling for the detail.
Take a look at Layout Configuration on how to configure the layout and format.