A Trendline Comparison chart is a type of chart used to compare trends or patterns between different data series over time. It typically displays multiple trendlines on the same graph to facilitate comparison.
This Trendline Comparison example below is displaying Open and Closed Incidents for the last 24 months.
Let's look at the Data and Chart options for this Trendline Comparison chart. It is displaying incident data, so it will be utilizing the incident table.
Conditions: Setting conditions allows you to query the table you are building the chart off of.
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.
Calendar Type: The calendar input can be set to a Standard Calendar or Fiscal Year.
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 and Secondary Date Field: A 'Date' field is designed to store date and time values. One Date field is set to "created" which groups opened incidents and the Secondary Date Field is set to "Closed" which groups closed incidents.
Now, let's look at the styling options that have been changed from the default Trendline Comparison chart style settings to provide more clarity to the chart. First a custom title of "Open/Closed Incidents - Last 24 Months" is set to provide a quick understanding of the data the Trendline Comparison chart is displaying.
Next, the Labels and Data Values toggles are engaged to display the values of the bars in the Trendline Comparison.
Finally, the Display Legend and Data Percentage toggles and engaged to display the legend of the Trendline Comparison chart.
