Skip to main content
Version: 9.5

Trend Chart

Use trend charts to analyze trends and changes in a value over time and find peaks and valleys of the data.

trend-chart

You can analyze the trend of any aggregated column, based on the data in any other column (usually a date), by using the Trend Charts feature within a grouped table cell. The trend is depicted as a line or bar chart that displays the following highlighted values:

  • Start value (gray)
  • End value (gray)
  • Minimum value (yellow)
  • Maximum value (red)

table

table

These values are also displayed in a tooltip when the cursor pauses on each chart.

Configure a Trend Chart​

The Trend Chart section only displays in grouped tables. You can add a Trend Charts in one of the following ways:

  • From the Trend Chart command in the options (three-dot) menu of the aggregated Column Pill.

    table

  • From the Configuration Panel, by selecting the +Add Trend Chart button, selecting the column to chart and the one to use for the trend.

Trend Chart Settings​

  • Chart Type - Select the bar or line option from the respective icons. The default is a line.

  • Column - Select values to display in the chart.

  • Trend by Column - Date or Numeric data types.

    If Trend by Column is a date data type, you can apply:

    • Date Grouping - Group your dates by year, quarter, months, weeks, and days.
    • Time Period - Select a period to display in the trend analysis (this year, last year, this quarter, last quarter, this month, last 6 months, and so on.).

    If Trend by Column is a numeric data type, you must limit the data points by setting the Max Data Points (default is 50).

    • Trend Sort - Sort the trend visualization in an ascending or descending manner. Applies to all datatypes.

    • Color - Select the color of the trend chart.

    • Type - Select the type of line chart to show (Line, Spline, or Step Line). This setting only applies if a Line Trend Chart has been selected.

    • Fill - Set to none to show a regular line chart or to “Below” to fill the area below the line. This setting only applies if a Line Trend Chart has been selected.

    • Tooltips - Show or hide tooltips on the trend chart within the table.

      tooltip

  • Show Value - Show or hide the aggregated values alongside the trend visualization in each cell. You can widen the column to display the label and the chart.

    table

Additional Resources​