About Chart Types and Visualization Options

You can use the available chart types and visualization options when creating query-based widgets. These options enable the quick and easy interpretation of data.

Visualization Option Description
Line Chart

Line chart

View data as a line, with time displayed along the X axis and specific attributes measured along the Y axis. A third attribute can be used to determine the color of the line.

Here are the visualization options available with the Line Chart:

  • Y axis: Select the data attribute you want projected on the Y axis. Y axis supports numeric data attributes and only those are listed.
  • X axis: Select the data attribute you want projected on the X axis. In a Line Chart, only a time-related data attribute can be projected.
  • Series: Select the data attribute that you want to plot in separate series in the chart. For example, add the groupBy clause with a dimension in the query and view separate series for the various values of that dimension. In the following query, the CPU utilization metric in the oracle_oci_database namespace is grouped by the resourceName dimension and separate series are displayed for each of the resources.
    CpuUtilization[auto].groupBy(resourceName).mean()
  • Color by: Select the data attribute to whose values you want to assign distinct colors. Typically, the Color by option is used along with the Series option to assign distinct colors to the separate series.
  • X axis title: Specify a title for the data attribute projected on the X axis.
  • Y axis title: Specify a title for the data attribute projected on the Y axis.
  • Legend: Select an option to specify whether a legend should be displayed and the location of the legend in the widget.
  • Correlated tooltips: Select Yes to correlate the tooltips across all your query-based widgets in the dashboard.
  • Data cursor: Select Yes to view the tooltip when you hover the mouse over the widget.
  • Stacked: Select Yes if you want to stack the data attributes displayed in the chart, by color.
  • Hide and show behavior: Specify the behavior for hiding and showing data when a legend item is clicked. When data is hidden, the Y axis can be optionally rescaled.
    • None: Hide and show behavior is disabled.
    • With rescale: Rescales the Y axis dynamically when data is hidden or displayed by clicking a legend item.
    • Without rescale: Y axis remains static and does not adjust when data is hidden or displayed through interactions with the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
  • Zoom and scroll: Specify the zoom and scroll behavior of the chart by selecting one of the following options:
    • Delayed: When zooming or scrolling, the chart will wait to update until the zoom or scroll action is completed.
    • Delayed scroll only: Zooming is disabled, and the chart will wait to update until the scrolling action is completed.
    • Live: When zooming or scrolling, the chart updates continuously as it's being adjusted.
    • Live scroll only: Zooming is disabled, and the chart updates continuously when scrolled.
    • Off: Zoom and scroll are disabled.

    If you select the Delayed scroll only or Live scroll only option, the Initial zooming field is displayed and you can select from the following options:

    • First: Zoom in on the first data points on the X axis that can fit within the plot area.
    • Last: Zoom in on the last data points on the X axis that can fit within the plot area.
    • None: Initial zooming is not specified.
  • Y axis min: Specify the minimum value for the Y axis.
  • Y axis max: Specify the maximum value for the Y axis.
  • Reference object value: Specify a numeric reference value on the Y axis. When specified, a horizontal line appears in the widget at the specified value, serving as a benchmark or threshold. In addition, the following new fields are displayed:
    • Reference object color: Specify a hexadecimal color code in the #000000 format to define the color of the reference line.
    • Reference object text: Specify a label for the line, which will be displayed in the legend.
  • Y axis scale: Select an option to determine whether the Y axis will represent data in the linear or log scale.
  • Line width: Specify a numeric value to determine the width of the line.
  • Marker displayed: Select an option to control the visibility of data markers.
  • Legend height percentage or Legend width percentage: Specify a numeric value to set the height or width of the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
Area Chart

Area chart

View data as a filled-in area in which specific attributes are measured along the X and Y axes.

Here are the visualization options available with the Area Chart:

  • Y axis: Select the data attribute you want projected on the Y axis. Y axis supports numeric data attributes and only those are listed.
  • X axis: Select the data attribute you want projected on the X axis. In the X axis you can opt to display the name of the metric, namespace, and so on.
  • Series: Select the data attribute that you want to plot in separate series in the chart.
  • Color by: Select the data attribute to whose values you want to assign distinct colors. Typically, the Color by option is used along with the Series option to assign distinct colors to the separate series.
  • X axis title: Specify a title for the data attribute projected on the X axis.
  • Y axis title: Specify a title for the data attribute projected on the Y axis.
  • Legend: Select an option to specify whether a legend should be displayed and the location of the legend in the widget.
  • Correlated tooltips: Select Yes to correlate the tooltips across all your query-based widgets in the dashboard.
  • Data cursor: Select Yes to view the tooltip when you hover the mouse over the widget.
  • Stacked: Select Yes if you want to stack the data attributes displayed in the chart, by color.
  • Use solid color: The area that represents the presence of data in an Area Chart is covered in solid color.
  • Hide and show behavior: Specify the behavior for hiding and showing data when a legend item is clicked. When data is hidden, the Y axis can be optionally rescaled.
    • None: Hide and show behavior is disabled.
    • With rescale: Rescales the Y axis dynamically when data is hidden or displayed by clicking a legend item.
    • Without rescale: Y axis remains static and does not adjust when data is hidden or displayed through interactions with the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
  • Zoom and scroll: Specify the zoom and scroll behavior of the chart by selecting one of the following options:
    • Delayed: When zooming or scrolling, the chart will wait to update until the zoom or scroll action is completed.
    • Delayed scroll only: Zooming is disabled, and the chart will wait to update until the scrolling action is completed.
    • Live: When zooming or scrolling, the chart updates continuously as it's being adjusted.
    • Live scroll only: Zooming is disabled, and the chart updates continuously when scrolled.
    • Off: Zoom and scroll are disabled.

    If you select the Delayed scroll only or Live scroll only option, the Initial zooming field is displayed and you can select from the following options:

    • First: Zoom in on the first data points on the X axis that can fit within the plot area.
    • Last: Zoom in on the last data points on the X axis that can fit within the plot area.
    • None: Initial zooming is not specified.
  • Y axis min: Specify the minimum value for the Y axis.
  • Y axis max: Specify the maximum value for the Y axis.
  • Reference object value: Specify a numeric reference value on the Y axis. When specified, a horizontal line appears in the widget at the specified value, serving as a benchmark or threshold. In addition, the following new fields are displayed:
    • Reference object color: Specify a hexadecimal color code in the #000000 format to define the color of the reference line.
    • Reference object text: Specify a label for the line, which will be displayed in the legend.
  • Y axis scale: Select an option to determine whether the Y axis will represent data in the linear or log scale.
  • Marker displayed: Select an option to control the visibility of data markers.
  • Legend height percentage or Legend width percentage: Specify a numeric value to set the height or width of the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
Bar Chart

Bar chart

View data as a bar chart in which specific data attributes are measured along the X and Y axes. A third attribute can be used to determine the color of the bars.

Here are the visualization options available with the Bar Chart:

  • Y axis: Select the data attribute you want projected on the Y axis. Y axis supports numeric data attributes and only those are listed.
  • X axis: Select the data attribute you want projected on the X axis. In the X axis you can opt to display the name of the metric, namespace, and so on.
  • Series: Select the data attribute that you want to plot in separate series in the chart.
  • Color by: Select the data attribute to whose values you want to assign distinct colors. Typically, the Color by option is used along with the Series option to assign distinct colors to the separate series.
  • X axis title: Specify a title for the data attribute projected on the X axis.
  • Y axis title: Specify a title for the data attribute projected on the Y axis.
  • Legend: Select an option to specify whether a legend should be displayed and the location of the legend in the widget.
  • Correlated tooltips: Select Yes to correlate the tooltips across all your query-based widgets in the dashboard.
  • Data cursor: Select Yes to view the tooltip when you hover the mouse over the widget.
  • Stacked: Select Yes if you want to stack the data attributes displayed in the chart, by color.
  • Hide and show behavior: Specify the behavior for hiding and showing data when a legend item is clicked. When data is hidden, the Y axis can be optionally rescaled.
    • None: Hide and show behavior is disabled.
    • With rescale: Rescales the Y axis dynamically when data is hidden or displayed by clicking a legend item.
    • Without rescale: Y axis remains static and does not adjust when data is hidden or displayed through interactions with the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
  • Zoom and scroll: Specify the zoom and scroll behavior of the chart by selecting one of the following options:
    • Delayed: When zooming or scrolling, the chart will wait to update until the zoom or scroll action is completed.
    • Delayed scroll only: Zooming is disabled, and the chart will wait to update until the scrolling action is completed.
    • Live: When zooming or scrolling, the chart updates continuously as it's being adjusted.
    • Live scroll only: Zooming is disabled, and the chart updates continuously when scrolled.
    • Off: Zoom and scroll are disabled.

    If you select the Delayed scroll only or Live scroll only option, the Initial zooming field is displayed and you can select from the following options:

    • First: Zoom in on the first data points on the X axis that can fit within the plot area.
    • Last: Zoom in on the last data points on the X axis that can fit within the plot area.
    • None: Initial zooming is not specified.
  • Y axis min: Specify the minimum value for the Y axis.
  • Y axis max: Specify the maximum value for the Y axis.
  • Reference object value: Specify a numeric reference value on the Y axis. When specified, a horizontal line appears in the widget at the specified value, serving as a benchmark or threshold. In addition, the following new fields are displayed:
    • Reference object color: Specify a hexadecimal color code in the #000000 format to define the color of the reference line.
    • Reference object text: Specify a label for the line, which will be displayed in the legend.
  • Y axis scale: Select an option to determine whether the Y axis will represent data in the linear or log scale.
  • Legend height percentage or Legend width percentage: Specify a numeric value to set the height or width of the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
Pie Chart

Pie chart

View data as a pie chart to see values of an attribute as a fraction of the whole.

Here are the visualization options available with the Pie Chart:

  • Value: Select the data attribute you want displayed in the chart.
  • Series: Select the data attribute that you want to plot in separate series in the chart.
  • Color by: Select the data attribute to whose values you want to assign distinct colors. Typically, the Color by option is used along with the Series option to assign distinct colors to the separate series.
  • Legend: Select an option to specify whether a legend should be displayed and the location of the legend in the widget.
  • Pie inner radius: Specify a value between 0 and 1 to define the inner radius of the pie chart.
  • Legend height percentage or Legend width percentage: Specify a numeric value to set the height or width of the legend.
    Note

    This field is only displayed if the Legend option is enabled for the chart.
Scatter Chart

Scatter chart

View data as a scatter chart with specific attributes measured along the X and Y axes.

Here are the visualization options available with the Scatter Chart:

  • X axis: Select the data attribute you want projected on the X axis.
  • Y axis: Select the data attribute you want projected on the Y axis.
  • Color by: Select the data attribute to whose values you want to assign distinct colors.
  • X axis title: Specify a title for the data attribute projected on the X axis.
  • Y axis title: Specify a title for the data attribute projected on the Y axis.
  • Zoom and scroll: Specify the zoom and scroll behavior of the chart by selecting one of the following options:
    • Delayed: When zooming or scrolling, the chart will wait to update until the zoom or scroll action is completed.
    • Delayed scroll only: Zooming is disabled, and the chart will wait to update until the scrolling action is completed.
    • Live: When zooming or scrolling, the chart updates continuously as it's being adjusted.
    • Live scroll only: Zooming is disabled, and the chart updates continuously when scrolled.
    • Off: Zoom and scroll are disabled.

    If you select the Delayed scroll only or Live scroll only option, the Initial zooming field is displayed and you can select from the following options:

    • First: Zoom in on the first data points on the X axis that can fit within the plot area.
    • Last: Zoom in on the last data points on the X axis that can fit within the plot area.
    • None: Initial zooming is not specified.
  • Y axis min: Specify the minimum value for the Y axis.
  • Y axis max: Specify the maximum value for the Y axis.
  • Reference object value: Specify a numeric reference value on the Y axis. When specified, a horizontal line appears in the widget at the specified value, serving as a benchmark or threshold. In addition, the following new fields are displayed:
    • Reference object color: Specify a hexadecimal color code in the #000000 format to define the color of the reference line.
    • Reference object text: Specify a label for the line, which will be displayed in the legend.
  • Y axis scale: Select an option to determine whether the Y axis will represent data in the linear or log scale.
Bubble Chart

Bubble chart

View data as a bubble chart with specific attributes measured along the X and Y axes. A third attribute can be used to determine the size of the bubble.

Here are the visualization options available with the Bubble Chart:

  • X axis: Select the data attribute you want projected on the X axis.
  • Y axis: Select the data attribute you want projected on the Y axis.
  • Size: Select a data attribute to whose values you want to assign size.
  • Color by: Select the data attribute to whose values you want to assign distinct colors.
  • X axis title: Specify a title for the data attribute projected on the X axis.
  • Y axis title: Specify a title for the data attribute projected on the Y axis.
  • Zoom and scroll: Specify the zoom and scroll behavior of the chart by selecting one of the following options:
    • Delayed: When zooming or scrolling, the chart will wait to update until the zoom or scroll action is completed.
    • Delayed scroll only: Zooming is disabled, and the chart will wait to update until the scrolling action is completed.
    • Live: When zooming or scrolling, the chart updates continuously as it's being adjusted.
    • Live scroll only: Zooming is disabled, and the chart updates continuously when scrolled.
    • Off: Zoom and scroll are disabled.

    If you select the Delayed scroll only or Live scroll only option, the Initial zooming field is displayed and you can select from the following options:

    • First: Zoom in on the first data points on the X axis that can fit within the plot area.
    • Last: Zoom in on the last data points on the X axis that can fit within the plot area.
    • None: Initial zooming is not specified.
  • Y axis min: Specify the minimum value for the Y axis.
  • Y axis max: Specify the maximum value for the Y axis.
  • Reference object value: Specify a numeric reference value on the Y axis. When specified, a horizontal line appears in the widget at the specified value, serving as a benchmark or threshold. In addition, the following new fields are displayed:
    • Reference object color: Specify a hexadecimal color code in the #000000 format to define the color of the reference line.
    • Reference object text: Specify a label for the line, which will be displayed in the legend.
  • Y axis scale: Select an option to determine whether the Y axis will represent data in the linear or log scale.
Table

Table

View data in a tabular format, with columns for each of the specified attributes.

Here are the visualization options available with the Table chart:

  • Columns: Add or remove columns.
  • All columns: Select to display all columns.