How to Build Complex Metrics With a Formula Block

To build complex metrics with a formula block, you drag the block onto the panel and configure the calculation there. The metric does not need to exist as a field anywhere first.

Why useful metrics often go unmeasured

The gap is rarely conceptual. Everyone knows what they want to measure; the obstacle is that it requires a calculation.

Ratios that would need a new field on every record
Metrics recalculated in a spreadsheet each month
Derived figures nobody maintains consistently
Questions abandoned because answering them was too much work

Field-based versus calculated metrics

Approach	How it works	Drawback
Field-based	A field stores the value on each record	Needs maintaining, and changes require a data migration
Formula field	Calculated per record on the table	Right for per-record values, not panel-level metrics
Formula block	Calculated on the dashboard itself	Lives with the panel, so it is configured where it is read

How to configure it in Jestor

Press B in Jestor to enter build mode on the panel.
Drag in the block designed for complex metrics.
Configure the formula for the calculation you need.
Apply filters so only the relevant records are included.
Format the result — percentage, currency, or abbreviated — and set decimal places.

Why choose Jestor for derived metrics?

Jestor supports formulas at both levels: per-record formula fields on tables, and panel-level calculations on the dashboard. That means a metric is defined where it belongs rather than forced into the wrong layer.

Composite indicators cover the common case of crossing two variables, and the formula block handles everything beyond it.

Frequently Asked Questions

Do I need a field for every metric?

No, calculations can live on the panel. See jestor.com.

Can formulas run at record level too?

Yes, tables support formula fields.

Can I filter which records the formula uses?

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,