# \[🚀 Launched\] Our brand new Analytics Query Language, AQL!

**URL:** <https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533>\
**Category:** Product Releases\
**Tags:** aml\
**Created:** [June 1, 2023, 8:14am UTC](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533 "2023-06-01T08:14:10Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Khai\_To](https://community.holistics.io/user_avatar/community.holistics.io/khai_to/32/128_2.png) [@Khai\_To](https://community.holistics.io/u/Khai_To)\
**Post date:** [June 1, 2023, 8:15am UTC](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533/2 "2023-06-01T08:15:35Z")

</div>

_Do note that we are currently in the development phase, exploring various solutions, which may result in changes to syntax and UI in the future_

## Sub-group Calculation

With AQL Expression, you can perform **Subgroup Calculation** flexibly and easily without having to create SQL (or transform) Model.

You can refer to the video below for more information.

[https://cdn.holistics.io/community/amql/aql\_demo\_subgroup\_calculation.mp4](https://cdn.holistics.io/community/amql/aql_demo_subgroup_calculation.mp4)

Sample syntax

```js
sum(order_items.quantity) * 1.0 /
  eval(sum(order_items.quantity), exclude(users.age_group))

```

If you have any questions in the meantime, please don’t hesitate to ask.

---

_[View the full topic](https://community.holistics.io/t/launched-our-brand-new-analytics-query-language-aql/1533)._