A Spline Chart is a type of line chart that connects data points with a smooth curve instead of straight line segments. It's particularly useful for visualizing trends or patterns in data where there may be fluctuations or irregularities.
The Spline Chart example below is displaying Incidents created over the last 12 months.
Let's look at the Chart and Data options for the Spline Chart Example. The chart is displaying incident data, therefore it is utilizing the incident table.
โConditions: Setting conditions allows you to query the table you are building the chart off of.
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: A 'Date' field is designed to store date and time values. This Spline Chart is displaying incidents opened or created within the last 12 months. Therefore the Date Field is set to "Created - sys_created_on".
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.
Now, let's look at the Spline chart style settings that have been changed from the default style settings to give it more clarity. First, a custom title of "Opened Incidents - Last 12 Months" is set to provide quick insight into the data the Spline Chart is displaying.
Next, the Data Values toggle is engaged to display the values of opened incidents along the Spline Chart line.