Range Charts display a pair of values (low and high) for each data point to visualize a range of values rather than a single value. These charts emphasize the distance (range) between the two values.
Range Bar Chart is a variation of regular Bar Chart. While the Range Bar Chart visualizes two values along the horizontal axis at a time — a low value and a high value, in Bar chart, the values are plotted on the horizontal axis one by one. The Create Range Bar Chart walkthrough showcases plotting the average daytime hours across one year.
Range Bar Chart
Range Column Chart is a variation of regular Column Chart. While the Range Column Chart visualizes two values on the vertical axis at a time — a low value and a high value, in Column chart, the values are plotted on the vertical axis one by one. The Create Range Column Chart walkthrough showcases plotting the average daytime temperature variation across one year.
Range Column Chart
Range Area chart is a variation of regular Area Chart. While the filled area in Range Area chart is between its lowest and highest values, in Area chart, the filled area is between the line segments plotted by data values and the horizontal axis. The Create Range Area Chart walkthrough showcases plotting the average rainfall across one year.
Range Area Chart
The Range Area Chart fills in the area between the top and the bottom value for each data point.
The Range Bar and Range Column Plot properties discussed below can be accessed from the Properties Panel on selecting the Chart > Plot from the Report Explorer. You can access some of the important properties from the Plot's Smart Panel too. See Chart Smart Panels topic for more information. Both the Properties Panel and the Smart Panel can be accessed by right-clicking the plot in the design area.
The action to perform when a column or a bar is clicked. The action can be a hyperlink, a bookmark, or a drill-through.
The data labels for each column or bar.
The line style for the column and bar borders.
The name of the plot. By default, a chart containing a single plot has the plot name as 'Plot1'.
Contains the tooltip template settings. You can choose from the list of predefined settings or set your own in the Expression Editor.
The BarLineStyle settings are applied when the ShowBarLines property is set to True.
The Clipping Mode determines how a plot (columns or bars) extends within the plot area. The ClippingMode can be set to
The Offset is the percentage relative to the single-column width or a single bar height, by which the column and bar plots should move to the right or the bottom side, respectively.
The Opacity is the percentage value of the opacity of the plot fill color. 100% opacity means the columns or the bars are opaque while 0% opacity means that they are completely transparent.
Overlays property is a collection for superimposing the data trend on the column or bar plot data points. For more information, see Trendlines topic.
Rules control the appearance of plots based on specified conditions. For more information on conditions, see Rules topic.
Determines whether to show the connecting lines between the columns or the bars of the same Details Encoding or the same Category Encoding (if the Details Encoding is empty) across different categories.
Represents how null or empty values should be shown in the plot - Gaps (default), Connected, or Zeros.
Determines whether to display multiple data fields as a single data field. In other words, if this property is set to 'True', the columns or the bars appear stacked in case they represent multiple data fields. By default, the property is set to 'False'.
The BarSettings property specifies the percentage relative to the column width or the bar height that should be specified in order to change the shape of the columns or bars.
The Values encoding specifies the data values. The Values property is the collection of items and each item includes the following properties.
Type
The Type property provides 'Simple' and 'Complex' options to choose from. However, for Range Bar and Range Column plots, 'Complex' is acceptable.
Subfields
The Subfields property is the collection and takes a start field that goes to the lower value and an end field that goes to the upper value. Each subfield can have its own caption.
Aggregate
To show aggregated values such as Average, Count, and Sum instead of individual values, specify an Aggregate function.
If multiple data values are added in the Values encoding, a clustered plot is created.
The Category Encoding for Range Column and Range Bar plots forms the axis of the plot across which distinct categories are arranged. The Category encoding includes the following properties.
Values
The Values property is the collection and takes the field as a category.
SortingField
The SortingField defines the order in which the categories are displayed. It takes the default same as the Values field, but you can also specify another field to sort the categories.
SortDirection
The SortDirection defines the ascending or descending order in which the categories should be sorted.
SortingAggregate
The SortingAggregate property specifies the aggregate to use for sorting the categories.
The Details Encoding breaks down the data values into subcategories and produces additional groups. The Details property is the collection of items and each item includes the following properties that define the Details encoding:
The Color Encoding enables the color legend of the Category Encoding or Details Encoding to display a match between the column or bar colors and the data values. It includes the following properties:
Action
The action to take when the color legend is clicked.
Aggregate
Aggregates the value of Color expression.
ShowValuesName
If set to True, the legend is displayed based on the value specified in Details encoding or Color encoding.
Values
The Values is the collection where the value of the Color expression is specified. However, the Range Column and Range Bar plots take the first item from the collection.
If the Details Encoding is empty, the Range Column and Range Bar plots calculate distinct Color Encoding results for the categories produced by the Category Encoding, convert them to the background color of the corresponding columns or bars, and display the match in the legend.
Otherwise, Range Column and Range Bar plots calculate distinct Color Encoding results for the subcategories produced by the Details Encoding, convert them to the background color of the corresponding columns or bars subsections and display the match in the legend. In both cases, plots pick up colors from the Chart Palette.
In most cases, you will use the same configuration for both Details Encoding and Color Encoding to enable a visual map of data values breakdown.
The Text Encoding provides support of any dataset field in chart labels and tooltips and allows displaying additional info on the chart. When two text encodings are added, they are displayed by default with the ";" delimiter. A text encoding includes the following properties:
Aggregate
Aggregates the value of the Text expression.
Target
Specifies whether this text is for a Label or a Tooltip Label. The label format is controlled with the chart's Labels > Template property or Tooltip Template property.
The Template property can use both the predefined values and the added text encoding fields, for example:
Count:{Text0}
Sum:{valueField.value}
Template Key
A unique key, used in the chart plot's Labels > Template and Tooltip Template to access the text encoding value.
Value
A field, constant or expression to be displayed.
The Range Area Plot properties discussed below can be accessed from the Properties Panel by selecting the Chart > Plot from the Report Explorer. You can access some of the important properties from the Plot's Smart Panel too. See Chart Smart Panels topic for more information. Both the Properties Panel and the Smart Panel can be accessed by right-clicking the plot in the design area.
The action to perform when the range area plot is clicked. The action can be a hyperlink, a bookmark, or a drill-through.
The data labels for range area chart.
The line style for the range area plot borders.
The name of the plot. By default, a chart containing a single plot has the plot name as 'Plot1'.
Contains the tooltip template settings. You can choose from the list of predefined settings or set your own in the Expression Editor.
The Clipping Mode determines how a plot extends within the plot area. The ClippingMode can be set to
The Line Aspect determines the line style that connects data points.
The Opacity determines the opacity of areas filled with color. 100% opacity means that the plot fill color is opaque while 0% opacity means that the plot fill color is completely transparent.
Overlays property is a collection for superimposing the data trend on a plot. For more information, see Trendlines topic.
Rules control the appearance of plots based on specified conditions. For more information on conditions, see Rules.
Represents how null or empty values should be shown in the plot - Gaps (default), Connected, or Zeros.
Determines whether to display multiple data fields as a single data field. By default, the property is set to 'False'.
The Category Encoding of an Area plot creates an area between the axis and the line generated from the connected data points representing the periodic change. The Category encoding includes the following properties.
Values
The Values property is the collection and takes the field as a category.
SortingField
The SortingField defines the order in which the categories are displayed. It takes the default same as the Values field, but you can also specify another field to sort the categories.
SortDirection
The SortDirection defines the ascending or descending order in which the categories should be sorted.
SortingAggregate
The SortingAggregate property specifies the aggregate to use for sorting the categories.
The Colors Encoding enables the color legend of the Details or Category Encoding. It includes the following properties:
Action
The action to take when the report item is clicked.
Aggregate
Aggregates the value of Color expression.
ShowValuesName
If set to True, the legend is displayed based on the value specified in Details encoding or Color encoding.
Values
The Values is the collection where the value of the Color expression is specified. However, the area plots take the first item from the collection.
The Details Encoding breaks down the data values into subcategories and produces additional groups. The Details property is the collection of items and each item includes the following properties that define the Details encoding:
The Values encoding specifies the data values, and represents the collection of items and each item includes the following properties.
Type
The Type property provides 'Simple' and 'Complex' options to choose from. However, for Range Area plots, 'Complex' is acceptable.
Subfields
The Value property is the collection and usually takes a bound field. However, the Range Area plots take the first item from the collection.
Aggregate
To show aggregated values such as Average, Count, and Sum instead of individual values, specify an Aggregate function.
The Text Encoding provides support of any dataset field in chart labels and tooltips and allows displaying additional info on the chart. When two text encodings are added, they are displayed by default with the ";" delimiter. A text encoding includes the following properties:
Aggregate
Aggregates the value of the Text expression.
Target
Specifies whether this text is for a Label or a Tooltip Label. The label format is controlled with the chart's Labels > Template property or Tooltip Template property.
The Template property can use both the predefined values and the added text encoding fields.
Template Key
A unique key, used in the chart plot's Labels > Template and Tooltip Template to access the text encoding value.
Value
A field, constant or expression to be displayed.
