Configure and use a table visualization in Dynatrace
Displays the selected metrics as a table, one metric per column.
Change selection of metrics
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 %).
Alternative metric selection: the eye icon in a metric row indicates and toggles whether a metric is selected as part of the query.
You must select
Table to display this type of visualization.
When switching between visualizations, be aware that some visualization settings are visualization-specific.
If you select a visualization and configure Visual settings, and then switch to a different visualization, some of your visual settings for the first visualization may be ignored because they don't apply to the newly selected visualization. An information icon in the list of visualizations will alert you to the possibility.
If you switch back to the original visualization, you may need to reconfigure some visualization settings.
The fold transformation combines a data points list (a timeseries: a collection of data points over the time period) into a single data point.
- The default fold transformation is
Auto, which automatically selects the most appropriate time aggregation based on the metric.
- You can manually override
Autowith any of the following:
- If you need to see the last reported value for a metric (rather than an aggregation), select
Per-metric visual settings
Table column names are the same as the metric names by default. You can change the name of table column headings. The query definition retains the metric's original name.
To rename a column
In the Visual settings section, select for the metric/column you want to rename.
Edit the name, and then select the checkmark to save the new name.
Unit and Format
Use the Unit and Format settings to determine how your data is displayed. If you export to a CSV file, the Unit and Format settings are also reflected in the exported values.
Use the Unit setting to set the unit in which the metric is displayed.
None= No unit displayed
Auto= Dynatrace selects an appropriate display unit
- Other selections specify the exact unit to display. The options here depend on the metric's unit. A time metric, for example, offers alternative units for displaying time.
- To add a custom unit/suffix string, type the custom string in the Unit box and then select it from the list.
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. For example, where
- Other selections specify the number of decimal places to display:
When the basic unit of the metric is byte:
- If you set Unit to
Auto, Dynatrace automatically expresses the results in a human-readable unit, which in this case could be
Note: A byte-based unit can have either a binary or decimal base, which will determine whether Dynatrace selects, for example,
GB. If no base is defined in the metric itself, a decimal base is used.
- If the automatically selected unit isn't suitable in your case, you can force Dynatrace to express the same values in a specific unit (Unit =
- If you want to see raw data (no conversion), you can set Unit to
Noneand see the results in the basic unit of the metric (which in this case is bytes).
When the basic unit of a metric is dollars and cents:
- For smaller values, to see the results expressed in exact dollars and cents: set Unit to
Auto, and set Format to
0.00(to have two decimal places for the cents)
- For larger values, to see the results expressed in thousands, millions, or billions of dollars and no cents: set Unit to
bil, and set Format to
0(to see nothing after the decimal point).
When the basic unit for the metric is a count:
- To see an exact count: set Unit to
Auto, and set Format to
- To see a rough count: set Unit to something like
bil(depending on the magnitude of your values), and set Format to
0.0000(depending on how many decimal places make sense in combination with the selected Unit setting).
When setting threshold values:
- If you select a Unit (for example,
MiB), the Threshold settings are then prepared to match the selected unit, so you just need to enter threshold values without specifying
- If you set Unit to
Auto(to let Dynatrace automatically scale the displayed output), you still need to set Threshold values in a specific unit such as bytes.
To enhance your visualizations, you can set thresholds that are reflected in your visualization.
A table can have as many thresholds as there are metrics displayed on the table. This example has five metrics, five columns, each with a different threshold definition. Link cell color to thresholds is turned on.
Tile text color is adjusted automatically for contrast with the background threshold color.
Set table thresholds
To make per-metric threshold settings
- optional In the Threshold section, select Link cell color to thresholds
- Make per-metric threshold settings.
Select Add threshold as needed to add thresholds for another metric.
Hide or show threshold colors
To hide or show threshold colors (per threshold definition) without deleting the threshold settings, in the Thresholds section, select for that metric.
Delete threshold settings
To delete the threshold settings for a metric, in the Thresholds section, select the trash can icon for that metric.