Clustered column chart data settings

Required parameters

For clustered column charts, you must specify the following parameters:

• X axis field
  • Description: A data column heading so that its associated values are plotted on the X-axis. The selection forms the control parameter (or independent variable) for the chart.
  • Data types: Numeric (including time values) or categorical (that is, a set of string values).
• Y axis value field
  • Description: A data column heading so that its associated values are plotted on the Y-axis, for example, time values. The selection serves as a measured (or dependent) variable for the chart. You can specify multiple dependent variables for a chart.
  • Data types: Numeric (including time) or categorical.
• Cluster by field
  Note: This feature is not available if you specify multiple dependent variables, that is, if you add more than one column heading to the Y-axis.
  • Description: The data column used to group rows of data. All data sharing a common group-by value are collected together to form the individual areas, lines, colored bands in a bar or column chart, bars in a clustered chart and colored dots in a scatter plot. This is the mechanism for plotting multiple values on one chart. For example, if the X-axis displays time values in a clustered bar chart and the Y-axis CPU utilization values. If you specify that you want to group by server name values the bar chart plots clusters of bars for CPU utilization over time for each server.
  • Data types: Typically categorical.

Optional parameters

• Title
  • Description: A custom title for the Data Visualization chart.
  • Data types: User-provided text string.
• Custom Help URL
  • Description: A URL that references a custom help topic help for the chart instance. The help page is displayed when a user clicks the help icon () on the chart's toolbar.
  • Data types: Text string forming a fully qualified URL (that is, include http:// or https://).
• Page to launch
  • Description: Select a dashboard or page from a drop-down list. The selected page or dashboard is displayed when a user clicks the chart.
  • Data types: User selection.

Chart customizations

• Legend
  • Description: You can optionally place a legend at the top, bottom or side of the chart.
  • Data types: User selection.
• Cluster Gap
  • Description: The gap between clustered bars or columns.
  • Data types: Numeric.
• X axis minimum value
  • Description: The minimum value to be shown on the X-axis, independent of the retrieved data.
    Note: The specified value is ignored if the data plotted on the X-axis is not numerical.
  • Data types: Numeric.
• X axis maximum value
  • Description: The maximum value to be shown on the X-axis, independent of the retrieved data.
    Note: The specified value is ignored if the data plotted on the X-axis is not numerical.
  • Data types: Numeric.
• Y axis minimum value
  • Description: The minimum value to be shown on the Y-axis, independent of the retrieved data.
    Note: The specified value is ignored if the data plotted on the Y-axis is not numerical.
  • Data types: Numeric.
• Y axis maximum value
  • Description: The maximum value to be shown on the Y-axis, independent of the retrieved data.
    Note: The specified value is ignored if the data plotted on the Y-axis is not numerical.
  • Data types: Numeric.

Thresholds

• Threshold value 1
  • Description: The data column or fixed value for the first threshold line on a chart.
  • Data types: User selection.
• Threshold line color
  • Description: The color for the threshold line specified for Threshold value 1.
  • Data types: User provided string specifying a color or user selection from a color palette. To access the palette, click the color picker icon () associated with the field.
    Note: The color picker icon () updates to reflect the selected color.
    Instead of using the color picker icon, a user can provide a string that specifies a custom color, for example:
    • Hexadecimal values, for example, #12aabc.
    • Named color, for example, blue.
    • RGB values, for example, rgb(100, 150, 175)
    • RGBA values, for example, rgba(123, 234, 12, .5)
• Threshold value 2
  • Description: The data column or fixed value for a second threshold line on a chart.
  • Data types: User selection.
• Threshold line color
  • Description: The color for the threshold line specified for Threshold value 2.
  • Data types: User provided string specifying a color or user selection from a color palette.
• Shade color
  • Description: The shade color for the area between the specified thresholds.
  • Data types: User provided string specifying a color or user selection from a color palette.