Configure and use a stacked column visualization in Dynatrace
Shows query results as a stacked column.
Example stacked column
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 %
).
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.
- In the Visual settings section, select
for the metric you want to rename.
- 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.
Format
Use the Format setting to configure the number of decimal places displayed for the selected metric.
None
= No formattingAuto
= 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
- In the Visual settings section, select Add color override
- Select the series from the list
- Select the override color for that series
Axes
In the Axes section, you can control how the X axis and each Y axis of your visualization are displayed.
Name an axis
To name an axis
- In the Axes section, find the axis you want to rename.
- Select
next to the axis name.
- 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
- In the Axes section, find the axis you want to hide.
- Select
.
To unhide the axis, selectagain.
Define an axis position
To specify the side of the chart on which to display a Y axis
- In the Axes section, find the Y axis you want to move.
- Set Position to
Left
orRight
.
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
- In the Axes section, find the axis for which you want to define a minimum and maximum.
- 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.
The thresholds also affect how the tiles are displayed on your dashboards.
Set thresholds
To set thresholds
-
In the Thresholds section, enter threshold values
-
Adjust threshold colors optional
Hide or show threshold colors
To hide or show threshold colors without deleting the threshold settings, in the Thresholds section, select .