A Quantity Chart in Dashpivot Analytics is used to track numeric values recorded in form tables over time. It is commonly used for monitoring quantities such as hours, counts, costs, readings, or calculated values. This article explains how to create a Quantity Chart in Dashpivot Web and outlines key requirements for the data used.
Video Walkthrough
Prerequisites
Before you begin make sure you have the following:
Plan: Standard
Permission:
Home Folder: Super User or DP Organisation roles (Admin or Controller)
Team Folder: Super User, DP Organisation roles, DP Project roles, DP Team Controller, or DP Team Member
Skills Required: Dashpivot Analytics
Device Type: computer
Subscription: Dashpivot
Step-by-Step Instructions
Go to Analytics.
Create a Dashboard, or open an existing Dashboard.
Click 'Add chart' then choose 'Quantity'
Select which template will be the source, specify which table field, and which table column/cell and your chart will appear! By default it will be shown as the 'Bar chart'.
Try adjusting the settings or applying filters to analyse your data further.
Notes:
Quantity charts can only track numbers that are recorded inside a table using a Number or Formula column.
If you are using a prefilled table, only Number or Formula cells are supported.
If none of your templates contain a table with a number or formula column, the Quantity chart option will be disabled.
Quantity charts can be created at either a company level or within a specific Team folder.
In a Team folder, charts can only reference templates from the same Team folder.
At company level, charts can only reference templates in the Template Library that have been deployed to at least one Team folder.
Settings
Show as
This setting allows you to determine how the information is visualised
Bar chart
Line chart
Area chart
S-curve
The S-curve is only available for the 'bar chart' and allows you to overlay the cumulative quantity on the chart. This way you can see the volume per day/week/month as well as the growing total.
Breakdown by
This setting allows you to breakdown your data in more detail, displaying variables in different colours.
Workflow column
Created by
Project (available at company level)
Team (available at company level)
List (available for default tables, for any list columns in the same source table)
Common use cases
The Quantity chart is most useful for tracking numeric data typically recorded in daily reports or dockets, such as:
Tracking labour hours
Tracking number of people on site
Tracking costs
Tracking production quantities
Tracking material quantities
Tracking waste quantities
Tracking rainfall volume
Tracking delay minutes/hours/days
Tracking meter readings and calibrations
Tracking the number of rows in a table
If you want to track the number of rows in a table (you might have 1 row per person, per action, per piece of equipment, per issue, etc), you'll need to make use of our formulas feature: