Panels > Line Chart

Line Chart

A line chart connects points with lines to show changes in value. The horizontal axis represents a continuous progression, oftentimes, while the vertical axis displays values for a metric.

Line charts are ideal for representing continuous data and comparing trends in multiple series. For example: Tracking profit changes for different departments over time. You could have one line for each department, and the progression from left to right would show how the profit changed in successive quarters. Each line represents a department’s trend, making it easy to follow. Use line charts for time series data or when there’s a sequence on the x-axis, for example, dates, months, or quarters.

Creating a Line Chart

To create the Line chart

  • Create a New Dashboard Panel
  • Configure the Query and select the appropriate Data Source

(Refer to Dashboard Creation > Query)

Select Visualization

On the right side of the default screen, select Visualization as Time series to create an Line Chart panel.

Visualization Options 

Panel Options

There are multiple options to edit the properties of the panel. The first one is Panel Options. Enter a Name and Description for the Panel that you want to create. For instance, if you’re making a Line chart to track CPU usage, name the panel “Line Chart” and describe it as “CPU Usage.”

The Description is available in the top left corner and can be viewed by hovering over the i button.

The next part of Panel Options is Panel Link where you can point a link to any other website or dashboard of your choice. Enter a title, and URL, and select the ‘Open in a new Tab’ option if you want to open the link in a new tab. Click Save.

The URL can be a link to another dashboard or for getting help or useful info. When you click on a panel, it opens the link either in the same tab or a new tab, depending on your choices. For example, if you want to compare a default dashboard, just click the link to open it.

Tooltip

The next section is the Tooltip which is used to show the details of a panel.

As you can see, there is a green-colored tip showing wherever you click on the graph.

Legend

The next option is the “Legend,” which essentially allows you to choose how you want the legend values to appear: at the bottom or on the right.

As for the Legend mode, you can show it as:

  • List: The legends are displayed as a list.

  • Table: The legends are displayed as a table.

  • Hidden: The legends are not displayed.

Legend Values

You can select a number of values such as Last, First, Min, Max, Total, etc to show in the legend.

The values are the specific properties of the data after the latest refresh.

For example, when “Last” is selected, the last received data for the selected time period is shown.

The corresponding properties of the data will be displayed as a legend in the graph.

Axis

The next option is the Axis from where you can configure all the axis settings of your graph.

The further options that you can configure in your axis settings are:

  • Placement: Choose Y-axis placement-  Auto, Left, Right, and Hidden.
  • Label: Set a Y-axis text label. Different labels for multiple Y-axes can be set using override.
  • Width: Fix the axis width.
  • Soft Min: Adjust Y-axis limits with a Soft Min.
  • Soft Max: Adjust Y-axis limits with a Soft Max.
  • Show Grid Lines: Auto, On, Off.
  • Scale: Set the Y-axis values scale – Logarithmic or Linear.

Standard Options

The Standard Options are used to configure the other standard settings in the graph. It changes the way the graph appears.

The further options include:

  • Unit type: The type of Unit parameters.
  • Min: Minimum value to be considered.
  • Max: Maximum value to be considered.
  • Decimal: Total digits after the decimal point.
  • Display name: Series name to be displayed.
  • Color scheme: choose a color scheme for the graph.
  • No Value: What to show when there is no value.

Data Links

The Data Links option is similar to the Panel Link where you can link a URL and then open it in another tab. It is placed on the data instead of the Panel.

You can click on the data anywhere and the link option will appear.

It is used for an instant link that you want to appear anytime you click on the data.

Value Mappings

The Value Mappings option allows you to find a certain value and wherever the value lies, the display text is displayed. If there is a similar value in the data, it highlights in the form of the color selected.

Thresholds

The Threshold option is used to define the value threshold. You can set certain thresholds and color-code them.

There are three options to show threshold mode:

  • Not filled
  • As lines
  • As filled regions and lines

For instance, for CPU usage, use green for 30, yellow for 40, and red for 50, enabling quick detection of threshold breaches and immediate action or error alerts.

Add Field Override

Use the Add field Override option to modify existing fields. Overrides enable changes to field settings, same as the field options available in a particular panel, with the flexibility to select the target fields.

To add a field override, click on the Add Field Override button.

Select the Field type

Select a field type,  based on the following properties:

  • Name: Set properties for a specific field with a name.
  • Matching Regex: Set properties for fields with name matching a regex.
  • Type: Set properties for a field of a specific type (number, string, boolean).
  • Query: Set properties from the field for a specific query.
  1. Select the Field.
  2. Select the override property.
  3. Configure the override property.

You can add multiple fields overrides by repeating the same.

You have now learned how to configure the Line Chart, change the panel settings, and more. You can save and edit the panel later too.

Further Reading

FAQs

If you’re looking to monitor changes in performance metrics over time, such as tracking profit changes for different departments, you can use a line chart. Each line on the chart can represent a different department, allowing you to easily compare trends. For detailed steps on creating a line chart, refer to Creating a Line Chart.

To create a line chart, first, create a new dashboard panel and configure the query with the appropriate data source. Then, select ‘Visualization’ on the right side of the default screen and choose ‘Time series’ to create a line chart panel. For more detailed instructions, see Creating a Line Chart.

You can configure your line chart by adjusting various panel options such as name, description, panel links, tooltip, legend, axis settings, and more. For detailed customization options, refer to Visualization Options.

If the latest data isn’t showing up on your line chart, ensure the ‘Legend Values’ are set correctly, such as selecting ‘Last’ to display the most recent data. For more troubleshooting tips, see Legend Values.

To highlight specific values or set thresholds, use the ‘Thresholds’ option to define value thresholds and color-code them. This can help you quickly identify breaches and take immediate action. For more details, refer to Thresholds.

You can add panel links by configuring the ‘Panel Link’ option. Enter a title, URL, and select ‘Open in a new Tab’ if needed. This feature allows you to quickly navigate to other dashboards or external resources. For more information, see Panel Options.

Yes, you can configure various axis settings including placement, labels, width, and scale. For detailed options, see Axis.

Value mappings allow you to assign display text and colors to specific values. This can help in visually distinguishing data points. For more information on setting value mappings, see Value Mappings.

Use the ‘Data Links’ option to link URLs directly to your data points. This feature makes your line chart interactive, providing quick access to related information. For detailed steps, refer to Data Links.

You can use the ‘Add Field Override’ option to modify existing fields. This allows for detailed configuration of field settings. For more information, see Add Field Override.

Field overrides offer several advantages:

  • Configuration: Tailor the appearance and behavior of specific data fields.
  • Flexibility: Apply different settings to different types of fields (e.g., number, string, boolean).
  • Precision: Adjust properties such as axis placement, labels, and display formats to better represent your data.
  • Enhancement: Improve clarity and readability by highlighting important data points or trends.

Resources

Browse through our resources to learn how you can accelerate digital transformation within your organisation.