November 19, 2026
๐งฉ [Beta] Reuse AQL logic with user-defined functions
new feature
AQL user-defined functions are now in beta. Define your own AQL logic once as a function, and reuse it like a built-in function in any dimension or metric.
Before: the same logic, like a fiscal calendar, was copied into every field that needed it, with only the field name changed.
- A rule change meant updating every copy.
- A missed copy kept the old rule, so reports stopped matching.
Now: write the logic once as a function and call it wherever you need it.
- Update the function, and every dimension and metric that calls it follows.
- Group functions into modules in the library and import them into any dataset, so your team and Holistics AI use the same rules.
- Fields that call a function stay editable in the UI, unlike fields generated with AML
Func.
Good to know:
- A function returns one value, not a table.
- Recursion and optional inputs are not supported yet.
Learn more:
- AQL user-defined functions
- Templates, ready-to-use modules:
- SVG charts in tables: a box plot, progress bar or line chart in every table row
- ABC classification: group items into A, B and C by their share of a total
- Project profitability: discount factor, cash flows, NPV and payback year
๐ Want to try it? Request beta access, and we will turn it on for your workspace.