A Vertical Timed Bar Chart is a graphical representation of data over time using vertical bars. For the Vertical Timed Bar Chart example below we will looking at incidents from quarter to quarter.
Let's look at the Data and Chart options for this Vertical Timed Bar Chart Example. We are dealing with incidents for this chart, so want data from the incident table.
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: Think of trend type as the makers displayed on the X axis. Trend 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.
Now let's look at the styling options that have been changed from the default styling options to give this Vertical Timed Bar Chart more clarity.
This Vertical Timed Bar Chart has been given a custom title of Incidents by Quarter - Last Five Years. This provides quick understanding of what data the chart is displaying.
Next, the Labels and Data Values toggles are engaged to provide even more data clarity on the chart.
Next, the Display grid toggle is engaged to display a grid on the Vertical Timed Bar Chart.
