Formulas & calculations

If you can write a spreadsheet formula, you can do this.

Year-to-date, growth versus last year, running totals, rankings — the numbers every business meeting asks for, written the way you'd write them in a spreadsheet, checked as you type.

New calculation — Revenue YTDLooks good
ytd(sum(Revenue))

The running total, climbing month by month — written in one line.

The greatest hits

The numbers every meeting asks for.

  • Year-to-date — where are we against the year?
  • Versus last year — one toggle, change and % worked out
  • Running totals — cumulative anything, by any group
  • Rankings — top 10 with an automatic “Others” bucket
  • Moving averages — smooth the noise, keep the trend
  • Percent of total — every slice as a share of the whole
138 functions

From everyday to advanced, all in the box.

+−MathAbText31DatesifLogicΣStatistics%Time & share

One definition of the truth

Saved calculations live in a shared catalog. Define “Revenue” once and it means exactly the same thing on every dashboard, in every chart, for every person. The three-versions-of-the-same-number meeting is over.

Checked before it charts

Formulas are checked as you type, with problems pointed out in place. If a column a formula depends on changes later, the affected fields are flagged — never quietly wrong.

FAQ

Formula questions, answered.

Something else on your mind? Ask us directly — a person answers.

Do I need to know SQL?

No. If you can write a spreadsheet formula, you can write a Klayara formula. Most dashboards need no formulas at all — and when you want one, the editor suggests functions and checks your work as you type.

What kinds of calculations are built in?

138 functions across math, text, dates, logic and statistics — plus the business classics: year-to-date, growth versus last year, running totals, rankings, moving averages and percent of total.

Can we define a metric once and reuse it everywhere?

Yes. Saved calculations live in a shared catalog — define “Revenue” or “Active customers” one time and every dashboard, chart and person uses the same definition. No more three versions of the same number.

What happens if a formula is wrong?

It tells you before it charts. Formulas are checked as you type, with the problem pointed out in place. And if a column a formula relies on changes later, the affected fields are flagged instead of quietly showing a wrong number.

Can we compare this period to the last one?

With a single toggle. Any chart can show the previous period alongside, with the change and the percentage worked out for you — or use the year-over-year functions in a saved metric.

Bring your hardest metric.

The one nobody can agree how to calculate — tell us what it should mean, and we'll define it in Klayara together, once and for all.

Talk to sales

Prefer to see plans first? See pricing

Contact usWhatsApp