Record list
Latest Dynatrace
Use a record list visualization:
- When you want to see the actual records returned by the query at a glance.
- When you are interested in the structure of the records and how the field values are distributed.
- When you want to further explore the data via interactions.
Lists the records returned from the query. Some data has been obfuscated in the example.
Title
Use this field to add a title. The edit box is displayed at the top of the options panel.
- You can use emojis such as 😃 and 🌍 and ❤️.
- You can use variables.
Example:
- Define variables called
Status
andEmoji
in your dashboard. - Set Title to
Current $Emoji status is $Status
. - Set
Status
toGood
. - Set
Emoji
to🌍
.
The title will be displayed as Current 🌍 status is Good
.
Visualization
If you aren't sure that you chose the right visualization, use the visualization selector to try different visualizations.
Query limits
Use the Query limits section to check and adjust the Grail query limits per notebook section or dashboard tile. These settings determine the maximum limits when fetching data. Exceeding any limit will generate a warning.
Dashboard sections and notebook tiles created in Dynatrace earlier than version 1.296 are not affected. Those existing tiles/sections will return the same results as before.
Read data limit (GB)
The limit in gigabytes for the amount of data that will be scanned during a read.
Record limit
The maximum number of result records that this query will return. Default: 1,000 records. To see more records, you need to increase the value of Record limit.
-
If your query has no
limit
, such asfetch logsthe value of Record limit is applied. By default, you will see up to 1,000 records.
-
If your query also includes a
limit
, such asfetch logs| limit 2000the lower of the two values (either
limit
in your query, or Record limit in the web UI) is applied.In the example above, you would still see only 1,000 records unless you increased the value of Record limit.
Result size limit
The maximum number of result bytes that this query will return. For better performance with typical queries and smaller documents, the default is set to 1 MB.
Sampling (Logs and Spans only)
Results in the selection of a subset of Log or Span records.
Units and formats
To override the default units and formats in a dashboard or notebook visualization
-
Select to edit the visualization tile.
-
Select the Visualize tab.
-
Select Units and formats.
-
Select Override.
-
Select Override
-
In the dropdown list, select the item for which you want to add a unit override.
This is a numeric column of the underlying DQL result, so it varies according to the query. For example:
- A
fetch events
query returns events. The dropdown list here lets you select a numeric field (such astransfer_size
) from the results. - A
timeseries avg(dt.host.cpu.usage)
query returns a single timeseries foravg(dt.host.cpu.usage)
. That timeseries is then the only selectable option in the list.
- A
-
Define the override.
- Default unit: The base unit in which the values were captured. It's
None
if it was not included in the DQL result, or its automatically defined by the unit passed from the DQL result. This field doesn't lead to any conversion. - Displayed unit: Once you define a default unit, you can use Displayed unit for conversion. For example, if the DQL result defined your numeric value in the result as
Bytes
, Displayed unit now offers a suitable list of byte conversions such asKilobyte
andMegabyte
. Unlike the Default unit, the Displayed unit is always a numeric conversion. - Decimals displays the default number of decimals (degree of precision) to display. To see it in action, change the Decimals selection and observe the change in the visualization.
- Suffix displays the suffix to display after the unit. To see it in action, enter a string and observe the change in the visualization. When you don't find the unit you're looking for, you can use Suffix to display the desired unit.
- Default unit: The base unit in which the values were captured. It's
-
Turn on Abbreviate large numbers if you want to display large figures in abbreviated form. For example,
1053
becomes1.1K
.
To reset to defaults (discard override settings for the selected item), select the trash can next to the item.
This example uses a line chart, but the options apply to other visualizations.
-
In Dashboards, create a dashboard.
-
Select and, in the Snippets section of the menu, select Metrics > Chart average CPU across all hosts.
-
In the section edit panel, select the Visualize tab and select Line chart.
-
Select Units and formats.
-
Select Override.
-
In the dropdown list, select the metric for which you want to add an override. There's only one metric to select in this example.
-
Define the override for the displayed metric. You can observe your changes in the Y-axis of the chart.
-
Default unit displays
Percent (%)
, which is the default unit for the selected metric. Try a different setting, such asOne
to instead display the result as a fraction of 1. -
Displayed unit displays
Auto
. You can change it to a different unit, such asOne
to instead display the result as a fraction of 1.Only linear and static conversions are supported. For example, you cannot convert
Degree Celsius(°C)
intoDegree Fahrenheit(°F)
, or convertUsd(US$)
intoEur(€)
. -
Decimals displays the default number of decimal points (degree of precision) to display. To see it in action, change the Decimals selection and observe the change in the visualization.
For example, change this:
To this:
-
Suffix displays the optional suffix to display after the unit. To see it in action, enter a string and observe the change in the visualization.
-
To reset to defaults (discard override settings for the selected metric), select the trash can next to the metric.