IN vs Not IN two different cards

rahulrampa
rahulrampa Member
in Cards, Dashboards, Stories

Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9 other IDs that I haven't selected. I want both of these in the same dashboard using a single filter

Tagged:

Best Answer

Answers

  • jessdoe
    jessdoe Contributor
    Answer ✓

    Yes, just use include or exclude on each cards filter depending on if you want the results of the filter included or excluded.

    2023-11-10 12_32_19-Overview - Domo.png
    2023-11-10 12_31_20-Overview - Domo.png

  • bshipley
    bshipley Member

    @jessdoe I believe I share this user's question and I think the answer doesn't quite resolve this.

    If I understand correctly, I believe they are asking about a scenario where there are a total of 3 cards: 1 is the filter (where the id is selected) that is enabled with interaction filters and applied to 2 other cards where the data is shown: one card filters where id IN selected id and another card then filters where id NOT IN selected id.

    I tried doing as you suggested in each card, selected the dimension to filter and setting one to IN and the other to NOT IN, but the cards don't retain any information of IN or NOT IN regarding that filter unless you actually select value(s) from the filter ie. it doesn't work. When I select a value from the filter card, both subsequent cards then filter where id IN selected id rather than one doing IN and one doing NOT IN.

    Is it possible to do what we're asking?

Categories