• Home
  • How to use Dynatrace
  • Dashboards and reports
  • Charts and tiles
  • Configure and use a stacked column visualization in Dynatrace

Configure and use a stacked column visualization in Dynatrace

Shows query results as a stacked column.

Example stacked column

Stacked column example

Control which metrics are stacked

Your visualization can show any selection of metrics in a multi-metric query. The letter next to each metric in your query toggles display of that metric on or off.

In this example, you would change the selection from A (CPU usage % only) to both A and B (CPU usage % and Memory used %).

Change metric selection

Note: You can only stack metrics with the same unit.

Visual settings

Visualization

You must select Stacked Graph to display this type of visualization.

Resolution

Resolution is the X axis (time) granularity of the visualization.

  • To allow the Data explorer to automatically select an appropriate resolution for the selected timeframe, set Resolution to Auto
  • To specify a certain resolution, select one from the list

Some resolutions are unavailable for some timeframes. If you select an incompatible combination of timeframe and resolution, Dynatrace automatically selects a resolution and displays an explanatory message such as: Auto-resolution applied. Resolution value of [6 hours] applied. Selected timeframe doesn't allow for [5 minutes] resolution. To override auto-resolution, select a different resolution from the list.

Show legend

Whether to display a legend under the visualization.

Note that the legend is active: you can select a legend entry to toggle display of the corresponding entry on or off.

Connect gaps

To connect gaps in a chart, in the Visual settings section, turn on Connect gaps.

Per-metric visual settings

The Visual settings section also displays visualization options per metric selected for the query.

Rename a metric

You can change the name of a metric as it is displayed on the chart and in the chart legend. The query definition retains the metric's original name.

  1. In the Visual settings section, select Edit pen icon for the metric you want to rename.
  2. Edit the name, and then select the checkmark to save the new name.

Change chart mode

To change the chart mode for a metric, in the Visual settings section, select a new chart mode from the list.

Change color palette

To change the color palette for a metric, in the Visual settings section, select a new palette from the list.

Select color palette

Format

Use the Format setting to configure the number of decimal places displayed for the selected metric.

  • None = No formatting
  • Auto = Dynatrace selects an appropriate format
  • Other selections specify the number of decimal places to display: 0, 0.0, 0.00, 0.000

For example, where None would display 5.062357754177517 %, Auto would display 5.06 %.

Add color override

To force a different color (override the color palette) for a specific series such as a selected host

  1. In the Visual settings section, select Add color override
  2. Select the series from the list
  3. Select the override color for that series

Color override selection

Axes

In the Axes section, you can control how the X axis and each Y axis of your visualization are displayed.

Walkthrough of axis settings

In this walkthrough, you add some metrics to a visualization and see how to adjust the axis settings in the Axes section of the Settings for your graph. (This example uses a Graph visualization, but the same settings apply to other visualizations that have axis settings.)

  1. In the Dynatrace menu, go to Explore data.

  2. In the Data explorer, add metric builtin:host.mem.used, split by Host, and select Run query.

    • The X axis, which is displayed along the bottom of the graph, is the current timeframe as determined by the timeframe selector.
      • The X axis has no name by default, but you can name it: in the Axes section, find X axis, select Edit pen icon in the X axis row, change the name (for example, to Time), and then select the checkmark to save the new name.
      • To toggle the display of the X axis on and off, select Preview in the X axis row.
    • The Y axis by default is displayed up the left side of the graph.
      • There can be more than one Y axis on a chart. The first one is automatically labeled Y axis 1 in the Axes section. In this example, it displays memory used in GB, corresponding to the first metric you have added to your chart, Memory used (builtin:host.mem.used).
      • As with the X axis, you can name and hide/show the Y axis: find Y axis 1 in the Axes section and select Edit pen icon and Preview accordingly.
      • To move the Y axis to the right of the chart, change Position from Left to Right.
      • To specify the range of a Y axis, change Min, Max from Auto, Auto to numeric values. For example, set Min, Max for this metric (Memory used) to 5, 10 to chart values between those values.

    One Y axis

  3. Select Add metric and add metric builtin:host.cpu.usage, split by Host, and select Run query again.

    • The Y axis for the second metric (CPU usages %) is displayed up the right side of the graph to indicate CPU usage percentage. (If you moved the Y axis in the previous step, now they both run up the same side of the chart.)

    • In the Axes section, a new Y axis 2 section is displayed.

      Two Y axes

Additional Y axes are not created automatically for any subsequent metrics you add to the chart, but you can add them manually: after you add the metric to your query, select Add Y axis in the Axes section, select in the empty Axis Metric box, and then select the metric you want to display for the new axis. Below, a third metric has been added with a third Y axis for .NET memory consumption (Large Object Heap).

Three Y axes

Name an axis

To name an axis

  1. In the Axes section, find the axis you want to rename.
  2. Select Edit pen icon next to the axis name.
  3. Enter a new name and select the checkmark to save the change.
    The axis name is displayed vertically next to a Y axis and horizontally under the X axis.

Hide or show an axis

To hide an axis

  1. In the Axes section, find the axis you want to hide.
  2. Select Preview.
    To unhide the axis, select Preview again.

Define an axis position

To specify the side of the chart on which to display a Y axis

  1. In the Axes section, find the Y axis you want to move.
  2. Set Position to Left or Right.

Set an axis minimum and maximum

By default, minimum and maximum axis values are set automatically.

To set custom minimum and maximum values for an axis

  1. In the Axes section, find the axis for which you want to define a minimum and maximum.
  2. Change the value of Min, Max from Auto, Auto to a comma-separated pair of values corresponding to the values on the selected axis.

Thresholds

To enhance your visualizations, you can set thresholds that are reflected in your visualization.

This example shows a Graph visualization of CPU usage % (builtin:host.cpu.usage) before and after adding thresholds. The effect is similar for other visualizations with thresholds.

Graph - no thresholds

Data explorer graph - no thresholds

Same graph with thresholds added

Data explorer graph - thresholds

The thresholds also affect how the tiles are displayed on your dashboards.

Graph tile before and after thresholds

Dashboard tile - graph before and after thresholds

Set thresholds

To set thresholds

  1. In the Thresholds section, enter threshold values

    Set threshold values

  2. Adjust threshold colors optional

    Adjust the threshold colors

Hide or show threshold colors

To hide or show threshold colors without deleting the threshold settings, in the Thresholds section, select Preview.

Hide or show thresholds