Configure a top-list visualization in Dynatrace
The dashboards discussed here are classic dashboards created using the dashboarding functionality integrated with previous Dynatrace.
- For more about classic dashboards, see Dashboards Classic.
- For more about dashboards created with the Dashboards app in the latest Dynatrace, see Dashboards.
- To improve your dashboard experience, you can upgrade existing dashboards from Dashboards Classic to the Dashboards app in the latest Dynatrace.
To visualize your query results as a top list, select Top list from the list above the query definition, in the upper-left corner of the page.
This visualization does not display multiple metrics. If your query has multiple metrics configured, only the metric selected in the query editor is executed. (By default, the first metric is selected.)
To choose one metric from a multi-metric query, select the letter next to the metric or select the eye icon .
Example in Data Explorer
Example pinned to a dashboard as a tile
Change visualization
When switching between visualizations, be aware that some visualization settings are visualization-specific.
-
If you select a visualization and configure Settings for that visualization, and then you switch to a different visualization, some of your 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.
Change metric selection
By default, this visualization shows the first metric of a multi-metric query.
To select a different metric from a multi-metric query, you can select the letter next to the metric you want to visualize, or you can select the eye icon .
Settings
The Settings section is one of the expandable sections in the right panel of Data Explorer. The contents of the Settings section may vary depending on the visualization you have selected.
Fold transformation
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:Last value,Average,Count,Maximum,Minimum,Sum,Median,Value,Percentile 10th,Percentile 75th,Percentile 90th. - If you need to see the last reported value for a metric (rather than an aggregation), select
Last value.
Be aware that the Fold transformation setting affects the resolution.
-
If Fold transformation is set to
Autofor visualizationTable,Single value,Top list, orHoneycomb, theInf(infinity) resolution is used to maintain backward compatibility. If the chosen metric selector doesn't support theInfresolution, thefoldtransformation is automatically added to the end of the query. -
If Fold transformation is set to a value other than
Auto,foldis used.
Because all metric selectors are queried using the same total value mechanism (either fold or Inf), adding a new selector that requires fold might change the result of the other selectors.
To inspect the actual query used by Data Explorer, go to the Result section in Data Explorer and select > Copy request.
Settings per metric
The 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 Settings section, select
for the metric 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.
Unit
Use the Unit setting to set the unit in which the metric is displayed.
None= No unit displayedAuto= Dynatrace selects an appropriate display unitOther 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.
- In Advanced mode, you can use
:setUnit(<unit>)to select from a wider range of units.
Examples of order-of-magnitude notation in Dynatrace:
| Notation | Factor | Meaning |
|---|---|---|
k | 10^3 | kilo, thousand |
M | 10^6 | mega, million |
G | 10^9 | giga, billion |
T | 10^12 | tera, trillion |
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. For example, whereNonewould display5.062357754177517 %,Autowould display5.06 %.- Other selections specify the number of decimal places to display:
0,0.0,0.00,0.000
Examples
When the basic unit of the metric is bytes:
-
If you set Unit to
Auto, Dynatrace automatically expresses the results in a human-readable unit, which in this case could beGiB.A byte-based unit can have either a binary or decimal base, which will determine whether Dynatrace selects, for example,
GiBorGB. 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 =
B,KiB,MiB, orGiB). -
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 to0.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
k (thousand),M (million),G (billion), and set Format to0(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 - Set Format to
None
- Set Unit to
-
To see a rough count:
- Set Unit to
k (thousand),M (million),G (billion), orT (trillion), depending on the magnitude of your values - Set Format to
0.0,0.00, or0.0000, depending on how many decimal places make sense in combination with the selected Unit setting
- Set Unit to
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 specifyingMiB. - 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.
Add color override
To force a different color (override the color palette) for a specific series such as a selected host
- In the Settings section, select Add color override
Select the series from the list
Select the override color for that series
Threshold
The Threshold section is one of the expandable sections in the right panel of Data Explorer. The contents of this section may vary depending on the visualization you have selected. Use threshold settings to enhance your visualizations and tiles.
Set threshold values after you set Unit:
- If you set Unit first, the threshold settings are prepared to match the selected unit.
- If you change Unit after you set threshold values, the threshold values are not automatically adjusted to match the new unit setting.
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 .
