Skip to main content
Skip table of contents

Line chart

Description

Line charts facilitate the viewing of trends over time.

Line chart example

The NQL query must include a timestamp field and one or more aggregations.

Data shape

<timestamp>, <kpi1>, <kpi2>, …

NQL structure

Aggregated KPI over time

CODE
<event table> <time_duration>
...
summarize <kpi1>, <kpi2>, ... by <time_duration_granularity>
(list <time>, <kpi1>, <kpi2>, ...)

The list line is optional. If you don’t specify the list line, the system uses start_time by default. If you would like to use a different time field, for example end_time, you can use the list line to specify this.

Series names

Series names come from their corresponding variable names in the NQL query.

Series names illustration

The variable names are formatted with the following heuristic:

  • Underscores are replaced with spaces.

  • The first character of the variable is changed to upper-case.

NQL examples

Refer to the Live Dashboards NQL examples documentation for more information.

Line chart specific settings

Widget description (Optional): Enter an optional text description to explain, for example, how the metric should be interpreted, how it is calculated, or any subtleties to the metric. The title is required before the description can be entered. After you enter the description and press done, an info icon appears next to the title in the dashboard. When you hover over the icon, the information you have entered appears as an info tip.

Rating: Shade portions of the line chart in red or yellow to enable the viewer to more quickly assess whether the data is indicating an issue. Choose from:

  • 1 threshold: The line chart shows a red section to indicate a bad range.

One threshold rating
  • 2 thresholds: the line chart shows a red section to indicate a bad range and a yellow section to indicate an average range.


RELATED TOPICS

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.