[Launched - New Updates] Calculation Builder - Create Fields Without Code 🧮

Product Releases
1

AQL lets analysts build complex metrics much more easily, but learning it takes time. And we know not everyone has that luxury. That’s why we’re building Calculation Builder to let you tap into the full flexibility of AQL, through a point-and-click experience anyone can use.

Why you’ll love it

Zero coding required: Create, customize, compose metrics with just a few clicks.

image
image1920×1080 72.1 KB

Popular calculations: Build count, sum, average, running totals, and conditional metrics effortlessly.

image
image1920×1080 64.3 KB

Progressive learning: View the generated AQL behind your GUI calculations to gradually learn the language.

image
image1920×1080 75.9 KB

Advanced customization: Convert any GUI metric to AQL for further customization when needed.

image
image1920×1080 67.8 KB

Calculation Builder currently supports all basic aggregations (count, sum, average), conditional aggregations (count if, sum if), running totals, and more - all through a simple point-and-click interface.

Share your feedback

Calculation Builder is currently in beta. We’re still polishing things up, so some behaviors or options may evolve. Your feedback is incredibly valuable - let us know what works, what doesn’t, or what you’d love to see next!

:star: More calculations are coming up soon.

3 Likes
3

Calculation Builder (Updates): New calculations, Calculate from this, GUI custom dimensions, Metric controls

Hi folks, building fields just got easier :raised_hands:
Our latest Calculation Builder updates will give you more ways to work with ease.

New calculations: Concat, Date difference, Date add, Case when, and Rank – enabling you to work with text, dates, rankings, and classifications intuitively.

1920×1080 155 KB

Support for custom dimensions: Build custom dimensions with Calculation Builder using the new functions above.

1920×1080 200 KB

Calculation Builder anywhere: Access Calculation Builder across your Reporting tab - in the dataset fields panel, visualization settings, and tables, to define logic where you work.

1920×1080 186 KB

Composable metric with flexible controls:

  • Build new calculations based on existing ones.
  • Apply filters and customize grouping for advanced aggregations directly inside calculations.

1920×1080 222 KB

These updates help you create and refine calculations faster and more flexibly.
:rocket: There’s even more coming up. :rocket:

2 Likes
4

Calculation Builder (Updates): Available in Development space, GUI vs. Formula mode switching, Enhanced AAFs

Hi there :wave:
We’ve made some new tweaks to the Calculation Builder to make field creation more flexible and powerful :muscle:

Available in Development

You can now use the Calculation Builder in the development space, so you’ll get the intuitive GUI to speed up creating and testing your fields before publishing.

1920×1080 484 KB

GUI vs. Formula mode

Switching between the Calculation Builder and Formula view is now simple, so you can work in whichever mode feels most comfortable.

1920×1080 170 KB

Enhanced AAFs through Calculation Builder

Period over period, percent of total or moving calculations now can be converted to AQL, allowing you to extend it and combine it with other metrics.

Period‑over‑period calculations automatically match the date granularity in your visualizations, so there’s no need to adjust it yourself.

1920×1080 247 KB

Try them out and let us know your feedback :raised_hands:

4 Likes
5

Calculation Builder (Updates): Arithmetic Calculations (+, -, ×, ÷)

Calculation Builder: Arithmetic
Calculation Builder: Arithmetic1920×1080 186 KB

You can now perform basic math operations on your fields directly in the GUI:

  • Add (+) - e.g., Revenue + Tax
  • Subtract (-) - e.g., Revenue - Cost = Gross Profit
  • Multiply (×) - e.g., Price × Quantity = Total Order Value
  • Divide (÷) - e.g., Converted Users ÷ Total Users = Conversion Rate

Like other GUI calculations, you can compose these with existing metrics, or convert to AQL for further customization.

Try it out and let us know how it goes! :raised_hands:

6

[Calculation Builder - Upcoming] Percentile Calculations

Calculation Builder: Percentile
Calculation Builder: Percentile1920×1080 364 KB

Percentile calculations are coming to the Calculation Builder!

Create continuous and discrete percentiles directly in the GUI. Choose from common percentiles (P10, P25, P50, P75, P90, P95, P99) or enter a custom value.

Two types are supported:

  • Continuous percentile - interpolates between adjacent values
  • Discrete percentile - returns the closest actual value from the data

Example use cases

  • P10 customer lifetime value - identify your lowest-value segment to investigate churn risk
  • P25 vs P75 salary range - show the interquartile range for compensation benchmarking
  • P75 order value - understand where the bulk of revenue sits for pricing decisions
  • P90 response time - track performance while filtering out outliers
  • P95 session duration - identify power users by top 5% engagement time
  • P99 query execution time - catch extreme outliers for capacity planning

Stay tuned - more Calculation Builder capabilities are on the way!