Filtering using BeastMode with a plus
We have a uncommon situation here.
We receive a dataset view by Snowflake with raw data and aggregated data and they are distinguished by a filed named "Data Type" 😶
We have metrics in beast mode that look to raw data to calculate numerators and others that calculate denominators looking the aggregated data lines.
What i need is: when i filter one field (Provider, for exemple), DOMO needs to return that aggregated data, too.
When i tried in Analyser I Have this (at the aggregated data, the column Provider is filled with EXCEPT PROVIDER... to simulate the ALLEXCEPT of PowerBI):
That's whats happend when i filter a Provider without include the "EXPECT PROVIDER": The metric [ABS Category Growth (R$)] returns blank
But, when i select both, the metric return the correct value
Is there a way to instruct DOMO to do the addicional selection automatically?
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board