How to calculate indicators (sum, average, min, max) directly on the gauge chart without formulas

Direct calculation on the gauge chart is the chart's own ability to pull and calculate values — sum, average, min, max, or count — with filters applied right in the setup, without needing to prepare that calculation in another field beforehand. In Jestor, each gauge value can have its own independent filter.

The problem with calculating outside the chart before building it

Before, using a gauge chart required calculating the values ahead of time in another field, making the process more work than it should be for an indicator that's supposed to be quick to set up.

Sum: total of closed sales or open positions.
Average: the average value of a set of records.
Min / max: define the limits of the gauge's scale.
Independent filters: each calculated value can have its own filter.

Calculation type	When to use it
Sum	Total of closed sales or open positions
Average	Average value of a set of records
Min / max	Set the limits of the gauge's scale

How to configure a gauge chart with direct calculation in Jestor

Add the gauge chart: to the dashboard or app.
Choose the calculation type for the current value: sum, average, min, max, or count.
Set the minimum: manually or calculated from a field.
Set the maximum: for example, from a target field.
Apply specific filters: for each calculated value, if needed.

How to configure it in Jestor: a practical example is using the sum of closed deals as the current value, a manually set minimum, and a maximum calculated from a target field — the gauge shows real progress without preparing that calculation somewhere else.

Why choose Jestor for near-real-time target indicators?

Eliminating the "prep the calculation beforehand" step cuts the time to set up a gauge from several steps down to a single configuration — the chart already calculates, filters, and displays progress without relying on an auxiliary formula field.

Frequently Asked Questions

Do I need to create a formula field before using the gauge chart? No, the chart itself now calculates sum, average, min, or max directly.

Can I apply different filters to each value on the chart? Yes, you can apply specific filters to the minimum, maximum, and current values.

Is the gauge chart only for sales values? No, it can be used for any numeric indicator, like open positions or processes.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, the gauge chart calculates progress toward the target on its own, with no extra step of preparing a formula elsewhere.

Visit the official Jestor website and scale the efficiency of your operation.

How to create and share internal documents and ideas inside the management system

Jestor Docs is a full text editor built into the system, with heading, list, image, grid, and quote blocks, plus three permission levels per document. In Jestor, this removes the need for a separate text tool just to jot down an idea or document a process. The problem with documentation

How to train an AI agent with internal company documents and policies

Training an agent with documents means attaching files — a vacation policy, an HR manual — to an AI agent, so it can answer questions based on that content, even without a linked table. In Jestor, the same agent keeps context across follow-up questions in the same conversation. The problem with

How to create an internal AI chatbot to answer questions about a specific table

An internal chatbot linked to a table is a conversational agent set up in a few clicks, with a custom logo, colors, and tone of response, able to sum, filter, and list records from a specific table when asked. In Jestor, it's different from Builder AI: one queries

How to choose between pie or donut chart and customize colors, borders, and legends

Pie charts and donut charts represent exactly the same data — the difference is purely visual, with the donut leaving an empty space in the center. In Jestor, both formats are available with the same level of color, border, and legend customization. The problem with having only one circular chart format