A Stacked Horizontal Timed Bar chart is a type of bar chart that displays grouped data over time, with bars oriented horizontally and segmented into multiple parts stacked beside each other. Each segment within a bar represents a subgroup or category, and the length of each segment corresponds to its value.
The Stacked Horizontal Timed Bar chart example below is displaying Incidents created in the last 12 months by the incident Categories.
Now, let's look at the Data and Chart options for this Stacked Horizontal Timed Bar 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.
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.
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 chart is displaying incident created within the last 12 months, so the Date Field input is set to "Created - sys_created_on".
Now, let's look at the style settings that have been changed from the default Stacked Horizontal Timed Bar Chart style settings to provide clarity to this chart. First, a custom title of "Created Incidents by Category - Last 12 Months" is set to provide a quick understanding of the data the chart is displaying.
Next, the Display Legend and Data percentages toggles are engaged to display the legend with the data percentages at the bottom of the chart.
Lastly, the Labels, Total Data Value, and Individual Values toggles are engaged to display the individual values and the total data values of the bars that make up the Stacked Horizontal Timed Bar Chart.
