A Trend Table chart is a visual representation of data that displays trends over time. It typically consists of rows and columns where each row represents a category or entity, and each column represents a specific time period. The cells in the table contain data points corresponding to the intersection of a particular category and time period.
The Trend Table example below is displaying open Incidents by Category for the last 24 months.
Now, let's look at the Data and Chart options for this Trend Table example. The Trend Table is displaying incident data, therefore utilizing the incident table.
Conditions: Setting conditions allows you to query the table you are building the chart off of.
Group by: Allows users to organize and aggregate data based on specific fields or criteria.
Aggregate Type: Refers to a data aggregation method or function used to combine or summarize data from multiple records. They allow users to perform calculations on sets of records to derive meaningful insights. Some common aggregate types include:
Count: Calculates the number of records in a set.
Count Distinct: counts the number of unique, non-duplicated values in a field.
Sum: Adds up the values of a specified field for a set of records.
Average: Computes the average value of a specified field for a set of records.
Minimum: Finds the minimum value of a specified field in a set of records.
Maximum: Determines the maximum value of a specified field in a set of records.
Trend Type: Trend Type refers to the general direction or pattern of change in a set of data points over a specific period of time.
Date Range: This input determines the range of time displayed on the line chart. The Date Range considers the dates associated with the field selected in the Date Field chart option.
Date Field: A 'Date' field is designed to store date and time values.
Sort by: Allows user to determine the order of the list. Sort by can set as Value Descending, Value Ascending, Alphabetically Descending, Alphabetically Ascending.
Now, let's look at the style settings that have been changed from the default Trend Table style settings. First a custom title of "Incidents by Category - Last 24 Months" is set to provide a quick understand of the data being displayed in the Trend Table.
Next, the header background color is set to blue.
Finally, the container Background and Border colors are set and a Border Radius of 6 is set to give slightly rounded edges.
