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
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!
