A Stacked Area Chart is a type of area chart where multiple data series are stacked on top of one another to show the total and the contribution of each individual series to that total. Each data series is represented by a colored area, and the areas are stacked on top of each other, forming a composite area that represents the total value at each point.
The Stacked Area chart example below is looking at opened incidents in the last 12 months, and grouping the incidents based on category as indicated by the legend at the bottom of the chart.
Let's look at the Data and Chart options for the Stacked Area Chart. The chart is displaying incident data, therefore the chart is utilizing the incident table.
Conditions: Setting conditions allows you to query the table you are building the chart off of.
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. The Stacked Area chart is displaying opened or created incidents over the last 12 months, therefore the Date Field input is set to "Created - sys_created_on" to only show opened incidents.
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.
Let's look at the Stacked Area Chart style settings that have been changed from the default style settings to give this chart more clarity. A custom title of "Opened Incidents by Category - Last 12 Months" is set to quickly provide insight into what data the chart is displaying.
Next, the Total Data Value toggle is engaged to display the total number of incidents open per month on the chart.