Dashboard Display Filter Logic for "Yes", and "Yes & No"

[DanTrudgeon]

Hi all, I cannot seem to wrap my head around the logic I need to put in place to create a new filter on an existing dashboard I've previously deployed.

I have a dataset with a field "Accessibility Impact" with either 'Yes' or 'No' as options; as well as <'Null'> from data entries populated before this field existed; and the goal is to have this filter avoid splitting the dataset, I want one option to show all entries with "Yes" as a response, and the other to show all data "Yes & No" (and even Null would be great so I don't have to retroactively update all "Null" values to "No" values.

[jcarlson]

When you configure a filter in a Dashboard, you can turn on the "None option". The label is a little misleading to me, it means "no filter", which is also "all data".

You can change the label as you like:

[DanTrudgeon]

Thanks Josh, appreciate it!

I had played around with the 'none' option, but it leaves me with three options because of the "Grouped Values" setting, avoiding my labels these would be, "Yes", "No", "Yes/No".

I tried deleting the "No" option below, but it does not seem to change anything on the dashboard.

I also tried changing to "Defined Values" and only populating a "Yes" option.

[jcarlson · Accepted solution]

You can have a "None" option on a Defined Values selector, too.

[DanTrudgeon]

Perfect, that was my missing piece. Thank you!