Filtering using BeastMode with a plus

bp_paulo_fernandes
bp_paulo_fernandes Member
in Charting

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

image.png

But, when i select both, the metric return the correct value

image.png

Is there a way to instruct DOMO to do the addicional selection automatically?

Tagged:

Best Answer

Answers

  • GrantSmith
    GrantSmith Coach

    There isn't a way built in to Domo which will allow you to get all the values except the one you're filtering. Domo works by running the filter first and then applying any beast modes. So with your beast mode attempting to get records which don't equal your filter there never will be any because they were filtered out beforehand.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • bp_paulo_fernandes
    bp_paulo_fernandes Member

    And is not possible to say to DOMO: "Hey, the user filtered that, but you need to include that other value, too"?

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    You might be able to get all of the data via a segment however you can't do an inverse filter like you're wanting to do.

    https://domohelp.domo.com/hc/en-us/articles/4403089503383-Creating-Segments-in-Analyzer

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories