Hi, People!
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" 😶
Anyway,
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?