Error Bar (Summarized Data)
With the Error Bar (Summarized Data) Chart, you can create an Error Bar using the data which is already summarized/aggregated.
For example, if you have the website access data and the number of conversions (number of people who visited this website and became paid users, for example) like the following.
2021-01-01
4435
123
2021-01-02
5345
211
2021-01-03
3851
134
2021-01-04
4421
183
2021-01-05
4245
199
2021-01-06
6113
252
2021-01-07
6541
258
2021-01-08
6018
312
2021-01-09
5109
280
:
:
:
You can create an Error Bar chart with this data by following steps.
Create a new chart and select "Error Bar (Summarized Data)" Type.
Select "Ratio" for the Calculation Type.
Assign "Date" to X Axis.
Assign "Convertion" to Y Axis.
Assign "Total Views" to Total Number.
Select "Circle" for the Marker.
Assignments
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.
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 eitherAs Number
to treat values as continuous values orAs 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
, assgin the mean value of each group.If the calculation type is
Ratio (%)
, assign the target count of each group.
Total Number - Assign a column that contains the total number of each group.
Standard Deviation - Assign a column that contains the standard deviation of each group. Only for the "Mean" Calculation Type.
Range Type - You can select an error bar range type from the following options. The default is
95% Confidence Interval
.90% Confidence Interval
95% Confidence Interval
99% Confidence Interval
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.
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.
Orientation - You can choose a chart orientation. Either 'Vertical' or 'Horizontal'.
Confidence Interval Range Calculation Formula
Calculation Type: Mean
Formula in R.
Calculation Type: Ratio (%)
Formula in R.
Reference Line
Style
You can change the error bar styles from the "Style" setting at Y-Axis. You can change the followings.
Line Width: Thickness of the error bars.
Circle Size: Size of the circle. Available only for "Circle" marker option.
Horizontal Bar Width: Length of the horizontal bar part of the error bars.
Highlight
Category
Limit Values
'Others' Group
Missing Value Handling
Show Detail
Layout Configuration
Save as an Image
Last updated
Was this helpful?