Compare "filtered" metric versus global average

[Khai_To]

Hi @dacou,

Just want to share an update with you that our team is actively working on this functionality.

You could refer to the Community Post below as the official announcement and follow the progress from there.

[Upcoming] Our brand new Analytics Query Language, AQL!

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. Sample syntax sum(order_items.quantity) * 1.0 / eval(sum(order_items.quantity), exclude(users.age_group)) If you have any questions…