Date Filter Exclude Nulls

I want to add a date filter that just excludes nulls and includes anything else. How can I do that?
It should be an analysis filter and not a dataset filter.



check this option, this may help you.

Naveed Ali

thanks @Naveed,
this option requires setting a start date and end date to be able to use Exclude nulls, while what I’m looking for is a filter to exclude nulls only.

@zainabs - Just make a minor change to @Naveed’s suggestion. Instead of using between dates select ‘After’ and then select a date before your date before your data begins.

1 Like

Hi @zainabs
Did Todd’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

@gillepa yes, Todd’s solution is what I used to do as a workaround for this issue. Wanted to make sure I’m not missing something obvious.

Thanks @todd.hoffman

1 Like