Another approach would be to use an aggregate filter. However I would recomend not having that grouping calculation for the combined key as a formula at the viz layer, maybe back that into a business view. The aggregate filter is essentially a having...

Hi Kxie,For this use case it may be more ideal to use a groupBy function approach as conditional(if) statements are generally going to be more resource intense, meaning latency. Other aggregate functions(avg etc) will work with this approach as well,...

Hi Prahba,We have released the MV Assistant which does exactly what you are asking for on our cloud platform. On premise will follow in the near future. Please review the following article:https://docs.incorta.com/cloud/guides-configure-tenants#mv-as...

The presentation variable may well be exactly what you need, review my comments on the post linked below. This may clarify a few things that may be helpful, different use case but similar approach is what I would use if I understand your ask. Use a M...