Progress Bar
A progress bar provides a visual representation of a metric’s progress. It is typically used to show task completion, remaining workload, or estimated time needed. Progress bars are usually displayed as rectangular bars, conveying the ratio of completion to a target.
Below is an example of how to create a progress bar.
Example: Create a progress bar in the Orders worksheet to display the completion ratio of annual sales against the target
Data Scope: Filter records in the “Orders” worksheet where the "Signed Date" is within the current year
Value: Select the “Total Sales” field
Target Value: Set a static or dynamic value to compare against, making it easy to visualize the completion ratio
Chart Configuration
1. Create a New Chart

2. Define the Record Scope
Choose whether to analyze records from a specific view or from all records (default).

Apply a filter: “Signed Date” is within the current year.
You can add more conditions if needed.

3. Set Value Field
Select the “Total Sales“ field.

4. Set Target Value
Set the target manually or use a field from the worksheet as a dynamic reference.

Completion Ratio = Actual Value / Target Value × 100%