Skip to main content

Column visualization

Lisa Wong
Updated

Best for visualizing data with few categories to compare.

The following options are available under each tab.

Tip: Customize and edit the selected visualization type in the Edit Tile dialog box by clicking Edit.

Plot tab

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 both the:
  • Series Positioning option, Grouped is selected in the Plot tab.
  • Scale Type is set to Ordinal in the X tab.
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.

Series tab

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 dimensions chosen is Count. When it is toggled on, it is displayed as Profile Variable Count.

Table 6. Customization section
Number Options Description Screenshot
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.

Values

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 turn on 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.

X

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.
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.

Y

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.
Left Axes and Right 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.
Related information

Related articles

Powered by Zendesk