Create business calculations that can be aggregated

Currently, we have the option to build a business calculation to create ie. categories that could be specific to an ad hoc query. Unfortunately, at this moment there is no possibility to use them as a group by and aggregate data based on the business calculation.

This is limiting, as we need in such cases add these fields as dimensions in the datasets, and frequently there are very ad hoc and not relevant for anything else but one specific usecase. This is why it would be great to have an option to use business calculations also with aggregations.

(ie. creating a business calculation of two subgroups, and then count rows for this business calculation).

Thanks @Karolina_Osiak for the suggestion. We’re currently revising our Holistics Expression to create a new version of Business Calculation, which is supposed to cover many new use-cases, including yours:

  • aggregate the field once more
  • calculate subgroup percentage
  • and many more!

We’ll have an official announcement when the beta of this new feature comes out :smiley:


That sounds great Tuan!

1 Like

Great news!! Thank you @tuan.nguyen !

Hi @tuan.nguyen - do we have any updates on this feature? I also have a similar use case as @Karolina_Osiak and would love to have the business calculation legends be used as a ad-hoc dimension/category which can be used to group by for other already aggregated metrics, etc. Thanks so much, and looking forward to the release or update about this!

Hi @Gaurab_Ghosh, welcome to our community

At the moment, our team is focusing on AQL Expressions development ( [Upcoming] Our brand new Analytics Query Language, AQL! - Product Releases - Holistics Community) so we have decided to stop enhancing capabilities for Business Calculation.

AQL Expressions are more powerful than Business Calculation so all of its use cases are expected to be covered with AQL.

You can refer to some of our documentation about AQL for more information ( Percent of Total | Holistics Docs).

1 Like