Bar visualization

Table 1. Series Positioning section
Options	Description
Series Positioning	Specifies how a set of data points is displayed. The following options are available: Grouped: Data point values are clustered side-by-side. Stacked: Values are added on the y-axis. Each data point value appears above the last. Stacked Percentage: Data point values are presented as percentages stacked on the y-axis, totaling 100%.
Grid Layout	Separates the chart into smaller charts. Each chart represents a single row or pivot from the Data table. Note: The maximum number of rows is 12. The Number of Charts per Row option appears when a grid layout is selected. If you have more than 12 rows or pivots, limit your data by entering a number between 1 and 12.
Show Percent of Previous	Displays the percent change arrows across the chart. The arrows display the percent of the previous value from left to right. Percentage arrows can be repositioned by dragging and dropping it while viewing the visualization. Note: This option is only available when the Series Positioning option Grouped is selected and the Scale Type in the X tab is set to Ordinal.
Inner Spacing	Sets the space between columns within a group. 0 is associated with minimum spacing between columns within a group. 1 is associated with the maximum space between columns within a group. Note: This option is only available when the Series Positioning option Grouped is selected.
Sort Stacks	Orders each slice of stacked or stacked percentage chart by the size of each stack. the following options are available: Default: Data points are ordered according to their position in the Data table. Ascending: Smallest data value is positioned at the bottom and the highest at the top. Descending: Largest data value is positioned at the bottom, and the lowest at the top. Note: This option is only available when the Series Positioning option Stacked or Stacked Percentage is selected.
Spacing	Sets spacing between column groups. 0 is associated with minimum spacing between column groups. 1 is associated with the maximum space between columns groups.

Table 2. Legend section
Options	Description
Hide Legend	Toggles the appearance of the data points legend on a chart. Note: This option is only available when there is more than one data point.
Legend Align	Specifies whether the data point legend appears on the left, center, or right of the chart. Note: This option is only available when Hide Legend is off, and there is more than one data point.

Table 3. Data section
Options	Description
Limit Displayed Rows	Show or hide rows in a visualization, based on their position in the results. The following options are available: Hide or Show: Specify whether to hide and exclude certain rows, or to show and display certain rows. First or Last: Specify whether the rows to be hidden or shown are the first or last rows in the Data results section. Number: Specify the number of rows to be hidden or shown. In the Data section, any excluded rows will be shown in a dark color. Note: This option depends on the row order. Changing the sort order or adding a row limit can affect which rows are shown or hidden.

Table 4. Colors section
Options	Description
Collection	Select from a group of pre-selected colors.
Palette	Choose one of several existing palettes or create a custom palette in the Custom tab. The following options are available: Type in a hex code or click Edit All to edit all hex codes at once. Click the Color Wheel button and click into the color wheel to select a color. The color's brightness can be adjusted with the slider at the bottom. Click the Add or Remove buttons to add or remove more colors in the color range. Note: The minimum number of colors in a palette is two. The maximum number of colors in a palette is five.
Reverse colors	Reverses the palette and applies colors at the: Left end of palette to higher values in the data range. Right end of the palette to lower values in the data range. The options change depending on the type of palette selected: Sequential or Diverging palettes: Each bar is colored on the scale of the palette in reverse. This starts with the color at the right end of the palette moving left. Categorical palettes: Colors are applied to each bar in reverse order, starting with the last color in the palette.

Table 5. Labels section
Options	Description
Show Full Field Name	Shows the name of the data source and the dimension. For example, the data source is in profile variables and the dimension chosen is Count. When it is toggled on, it is displayed as "Profile Variable Count".

Table 6. Customization section
Number	Options	Description
1	Arrow	Click the arrow to display all other options.
2	Color	Select a custom color for the data point. This option overrides the color palette in the Colors section.
3	Label	Enter a custom data point label. This impacts the chart legend and tool tips.
4	Type	Displays a different visualization type for the data point. The following options are available: Area Column Line Scatter Use this option to combine different visualization types on the same chart. For example, show one data point as a column and the other a line.
5	Points	Select the shape of the chart points if the Type is set to area, column, line, or scatter.

Table 7. Labels section
Options	Description
Value Labels	Toggles the appearance of value labels for each data point on the chart. Note: It is recommended to enable Value Labels so stakeholders can see the values if you export the dashboard as a PDF.
Label Null Columns	Toggles the appearance of labels for null data points.
Value Colors	Defines the color of value labels. This field takes a comma separated list of one or more color values. Values can be hex codes (for example, `#b79d0f`) or CSS color names (for example, `mediumblue`). Note: If multiple colors are added in the field, colors will be assigned to each data point in order. For example, the first data point in the table will be the first color, and so on.
Font Size	Sets the font size of value labels using any CSS size. For example, `12px`, `2 em`, or `100%`.
Value Rotation	Sets the rotation of value labels. Values can be between -360 and 360. Note: This option is only available when the Series Positioning option Grouped is selected.
Value Format	Specifies the format of the value. For more information, see Numeric formatting for visualizations.

Table 8. Labels section
Options	Description
Scale Type	Specifies how the x-axis scale is calculated and displayed. The following options are available: Automatic Based on Data: Scale is based on the underlying data. This is the default option. Ordinal: Data is plotted along the x-axis as evenly spaced, discrete entries, regardless of relative distance between data points. Time: Time data is plotted as time values. The x-axis is labeled with appropriate time increments. Note: The Scale Type option, Time may not work if a time dimension is not selected.
Reverse Axis	Toggles the direction of the x-axis. When the toggle is: Off: Values increase from left to right. On: Values decrease from left to right.
Show Axis Name	Toggles the appearance of the x-axis name label.
Custom Axis Name	Sets a custom name for the x-axis name label. Note: This option is only available when Show Axis Name is enabled.
Axis Value Labels	Toggles the appearance of value labels on the x-axis.
Gridlines	Toggles the appearance of gridlines extending from the x-axis. Gridlines are spaced based on scaling of the x-axis.
Label Rotations	Sets the rotation of the x-axis labels. Values can be between -360 and 360.
Time Label Format	Note: The Time Label Format may not work because of the lack of a time dimension.

Options	Description
Gridlines	Toggles the appearance of gridlines from the y-axis. Gridlines are spaced based on scaling of the y-axis.
Reverse Axes	Toggles the direction of the y-axis. When the toggle is: Off: Values increase going up. On: Values decrease going down.
Top Axes and Bottom Axes	Configure the chart's y-axis. Drag and drop a Measure to create a new axis.

Table 9. Configure Axis section

Options

Description

Scale Type

Specifies how the y-axis is calculated and displayed. The following options are available:

Linear: Data is plotted along the y-axis providing an equal distance between values. Most data is best displayed on a linear scale.
Logarithmic: Data is plotted along the y-axis using a logarithmic scale based on orders of magnitude. A logarithmic scale type shows the percentage of change. If the data set has a cluster of very small and very large values, the setting enables you to see variation in small values while showing large values.
Note: This option is only available:
- When in the Plot tab, the Series Positioning option Grouped is selected.
- For positive values.

Show Axis Name

Displays the appearance of y-axis name labels.

Show Axis Values

Toggles the appearance of y-axis values.

Unpin Axis From Zero

Focus on the area where data exists rather than showing the full scale starting as zero.

Axis Name

Enter a label for the selected y-axis.

Y Axis Format

Specifies the number format of the y-axis values, independent of underlying dimension or measure. For more information, see Numeric formatting for visualizations.

Tick Density

Sets the density of tick marks on the y-axis. The following options are available:

Default: Set ticks to the default density.
Custom: enables you to set ticks with custom density.

Minimum Value

Defines the minimum value for select y-axis.

Maximum Value

Defines the maximum value for the select y-axis.

Add Reference Line

Enables the creation of reference lines in a chart. Multiple lines are able to be created and to delete a reference line click the X button.

The following options are available once selected:

Options	Description
Type	Line: A horizontal line is plotted at the y-axis value entered in the Value field. The following options are available when this type is selected: Value: Specifies the point on the axis to plot the reference line. You can select from the Median, Average (Mean), Maximum, Minimum, and Custom settings. Range: A shaded range is plotted including and between the y-axis values entered in the Start Value and End Value settings. The following options are available when this type is selected: Start Value and End Value: Specifies the start and ending point on the axis to display a range. Line with Margins: A horizontal line is plotted at the y-axis value entered in the Value setting. Shaded ranges are plotted above and below the horizontal line, based on the values entered in the Margin Above and Margin Below options. The following options are available when this type is selected: Value: Specifies the point on the axis to plot the reference line. You can select from the Median, Average (Mean), Maximum, Minimum, and Custom settings. Margin Above and Margin Below: Specifies the shaded ranges to plot on either side of a reference. Note: If you select the Custom option in the Value drop down menu, you can enter a specific value or any of the following: `min` `max` `mean` `median`
Label	Enter a label to appear on the reference line. In the Label field, the following calculations are available to embed in double curly brackets {{ }}. median mean max min deviation (for population standard deviation) variance (for population variance) For example, if you enter `Average: {{mean}}` it will display as "Average: 123.4".
Label Position	Position the reference line label at the left, right, or in the center of the chart.
Color	Specify the color of the reference line. Choose one of several existing palettes or create a custom palette in the Custom tab. The following options are available: Click the Color Wheel button and click into the color wheel. The color's brightness can be adjusted with the slider at the bottom. Type in a hex code (for example, `#b79d0f`) or CSS color names (for example, `mediumblue`).
Value Format	Custom format the value shown in the reference line label. For more information, see Numeric formatting for visualizations.