All Collections
Chart Library
Timed Grouped Vertical Bar Chart
Timed Grouped Vertical Bar Chart

How to build a Timed Grouped Vertical Bar Chart

B
Written by Blake Hester
Updated over a week ago

A Timed Grouped Vertical Bar Chart is a specific type of bar chart that displays grouped data over time along the vertical 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 Vertical Bar Chart example below is displaying closed Incidents by Priority over the last 24 months.

Now, let's look how the Data and Chart options are set up for this Timed Grouped Vertical Bar Chart. This chart is displaying incident data, so the chart 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:

  1. Count: Calculates the number of records in a set.

  2. Count Distinct: counts the number of unique, non-duplicated values in a field.

  3. Sum: Adds up the values of a specified field for a set of records.

  4. Average: Computes the average value of a specified field for a set of records.

  5. Minimum: Finds the minimum value of a specified field in a set of records.

  6. 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 setting that have been changed from the default Timed Grouped Vertical Bar Chart style settings. A custom title of "Closed Incidents by Priority - Last 24 Months" is set to provide a quick understanding of the data the chart is displaying.

Next, the Labels toggle and Individual Values toggle is engaged to display the values of the bars on Timed Grouped Vertical Bar Chart.

Finally, the Display Grid toggle is engaged to display the grid on the chart, making it easier to read.

Did this answer your question?