Force a filter selection on filter card

ColemenWilson
ColemenWilson Coach
in Charting

I need (and have often needed) a way to force a selection on a filter card for a dashboard. I know I can set default values, but I need a way to ensure at least one selection is always made. Anyone found a workaround here?

If I solved your problem, please select "yes" above

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have a distinct count beast mode on your card and filter where that is one. Then set the no data message to be “Select a single value”

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

    Are you wanting to make sure a single filter has been selected or all of the applicable filters have been selected? If you have more than one filter that you want to make sure has a single value selected you can add additional beast modes in your filter to count the distinct values in each of those fields.

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

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have a distinct count beast mode on your card and filter where that is one. Then set the no data message to be “Select a single value”

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

    Hmm that doesn't seem to work if multiple filters on a page impact a card.

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Are you wanting to make sure a single filter has been selected or all of the applicable filters have been selected? If you have more than one filter that you want to make sure has a single value selected you can add additional beast modes in your filter to count the distinct values in each of those fields.

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

    Thank you @GrantSmith !

    If I solved your problem, please select "yes" above

  • jgrout
    jgrout Member

    @GrantSmith I am trying to do this at page level. I've got a page setup in domo with 3 cards, and all of them are intended to support the use case of only reviewing ONE PROGRAM. I have a dropdown filter card as the first card on the page, but if user doesn't select a program from the dropdown the cards below are displaying all the data for all the programs, which is not a proper use case of the dashboard. So I want to hide any data in the subsequent cards on the page until a user has made a selection.

Categories