[Beta - Updates] Calculation Builder - Create Fields Without Code 🧮

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.

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

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

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

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.


2 Likes

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.

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

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.


Composable metric with flexible controls:

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

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

1 Like

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.

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.

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.

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


3 Likes