Is there anyway to include chosen filters for LOD calculations? For example, a metric that calculates the total revenue, ignoring all filters except for user.status.
In tableau this is known as INCLUDE.
Hi Garrett,
Regarding your query, the function in Holistics that “calculates the total revenue, ignoring all filters except for user.status,” is keep_grains. You can find more details about this function in the Holistics documentation here.
Please note that keep_grains is not equivalent to Tableau’s INCLUDE. It will only retain the filters/grouping on user.status if it exists in the explore and will not add it into the explore like Tableau’s INCLUDE.
If you need functionality similar to Tableau’s INCLUDE, you should use our nested aggregation instead:
sum(unique(orders.status) | count(orders.id))
That is what I need, thank you. It would be helpful if that page was linked in the LOD documentation
1 Like