How to Build a Gauge Chart With Calculated Values

A gauge chart with calculated values works out its own figures instead of reading a single prepared field. Sums, averages, minimums, maximums, and record counts can all be computed directly on the chart.

Why gauges are usually underused

A gauge that can only display one existing field forces someone to maintain that field — which is why most gauges quietly go stale.

A progress field updated manually and forgotten
Targets hardcoded in a place nobody revisits
No way to filter which records count toward the figure
Gauges showing a number that no longer matches reality

What can be calculated on the chart

Sum — total closed value, for example
Average — mean deal size or mean resolution time
Minimum and maximum — range across the records
Record count — how many items meet the criteria
Filters — restricting the calculation to specific phases or conditions

How to configure it in Jestor

Press B in Jestor to enter build mode and edit the gauge.
Choose the calculated-value mode rather than pointing at a single field.
Select the operation — sum, average, minimum, maximum, or count.
Apply filters so only the relevant records feed the calculation, such as closed-won deals.
Set the minimum, maximum, and target values, which can also be calculated or read from a field.

Why choose Jestor for goal tracking?

Jestor lets the target itself come from a field, so a sales goal stored per record drives the gauge without anyone editing the chart when the goal changes.

Because the calculation and the filters live on the chart, the same underlying table can power several gauges measuring different slices of the operation.

Frequently Asked Questions

Can the target come from a field?

Yes, it can be calculated or read from a field. See jestor.com.

Which operations are available?

Sum, average, minimum, maximum, and record count.

Can I filter which records count?

Yes, filters apply to the calculation.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

How do you choose an AI tool for professional services operations teams in SMBs?

To choose an AI tool for professional services operations teams in SMBs, look for a platform that combines no-code tables for clients, engagements, and documents with AI features that answer messages, read documents, and summarize data, while keeping professionals in control of advice. In Jestor, these pieces work together,

How do you build a business continuity plan for a services firm?

To build a business continuity plan for a services firm, list critical processes and deadlines, identify risks such as system outages or key person absence, define backup options, assign roles, and test the plan. In Jestor, processes, risks, and actions are connected, so the firm keeps serving clients during disruptions.

What is the best way to run IT security awareness training for staff in a services firm?

A practical way to run IT security awareness training for staff in a services firm is to define short training modules, assign them to all staff, track completion, run simulated phishing tests, and schedule refreshers. In Jestor, staff, modules, and results are connected, so security habits become part of the

How do you route website lead forms to the right team in a services firm?

To route website lead forms to the right team in a services firm, ask for the service and company size in the form, route leads automatically to the right team, set response time targets, record follow-ups, and track conversion by source. In Jestor, forms, leads, and teams are connected,