Drop-down control filter default using an exclude list

[Jeremy_]

I have a drop-down filter that I want to exclude a value. I could create a page filter, but I need the ability to change the default on the fly if needed.

Let's say I have a drop-down of A, B, C, and nulls "". Instead of defaulting A, B, C,  in the filter default, I just want to Exclude nulls "". Because in reality I have 1000s of values that change, so I need a way to default to an exclude list.

Thanks in advance!

[lauratilton]

This is a little wonky, but how about setting it up so the user could decide whether to include nulls or not (note: this approach is a little more complex, but I think more elegant, than just a filter where you choose nulls, not nulls, or both): 

- Set up a parameter called “IncludeNulls” (Yes/No)

- Set up a calculated field (called Include?) that returns a 1 if the parameter is Yes, a 1 if the parameter is No and the Field is not null, or a 0 if the parameter is No and the Field is null. 

- Put on a report level filter to include where Include? = 1

- Add a toggle to your report using the IncludeNulls parameter. This could just be a drop-down but you could get creative with a slider made to look like a toggle if you used 0/1 instead of Yes/No for your parameter. 

Mehdi has a tutorial which includes how to configure a “toggle” (different use case) here

[ArkadyZagdan]

Pretty much what Laura said but rather use buttons / checkboxes to toglle and make it boolean type of a field.
its just more user friendly from an UX point of view.
Something like here:

Oh and doesnt need to be a parameter. You can do it simplier with just an IF statement

regards
Arkady Zagdan
Bigglo.pl

[lauratilton]

Sorry to take this on a tangent, but @ArkadyZagdan how would you go about doing an Include Nulls toggle (Yes/No) with just an IF statement? The way I was thinking about it, "Yes" means include everything, and "No" means include only non-nulls, and I can't think of a way to do that with IF. (It would be easy to do a toggle to go between nulls only and non-nulls only using IF, but I don't think that's what the OP wanted to do.) 

[Jeremy_]

These might do the trick. I'll play around with it this week.

That said, I'd still love to know if this capability is available or hidden. If you turn on URL parameters for Custom Bookmark Links at the report level, you can see the logic already exists with a keyword "exclude".

[lauratilton]

I think you're right that you could just use the exclude feature in custom bookmark links....but then users would need to always use that link to access the report in order to default to nulls excluded.