Date Filter Exclude Nulls

zainabs · December 19, 2022, 9:41am

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.

Thanks!

Naveed · December 19, 2022, 11:57am

Hi,

check this option, this may help you.

Regards,
Naveed Ali

zainabs · December 19, 2022, 12:31pm

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.

todd.hoffman · December 19, 2022, 2:04pm

@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.

gillepa · December 19, 2022, 9:58pm

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!

zainabs · December 20, 2022, 1:03pm

@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