A Timed Grouped Horizontal Bar Chart is a specific type of bar chart that displays grouped data over time along the horizontal axis. In this chart, each group represents a category or a set of related data points, and the bars within each group represent the values of those categories or data points at different time intervals.
The Timed Grouped Horizontal Bar Chart example below is looking at closed Incidents by Category for the last 24 months.
Now, let's look at the Data and Chart options for this Timed Grouped Horizontal Bar Chart. This chart is displaying incident data, therefore 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.
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 looking at closed incidents, so the Date Field is set to "Closed - closed_at".
Now, let's look at the style settings that have been changed from the default Timed Grouped Horizontal Bar Chart style settings. First, a custom title of "Closed Incidents by Category - Last 24 Months" is set to provide quick understanding of the data the chart is displaying.
Next, the Display legend toggle is engaged to show the legend at the bottom of the chart.
Lastly, the Labels toggle and Individual Values toggle are engaged to display the values of the bars that make up the Timed Grouped Horizontal Bar Chart.
