Date Filter Exclude Nulls

Q&A
, ,
1

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!

2

Hi,

check this option, this may help you.

image
image824×970 43.8 KB

Regards,
Naveed Ali

3

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.

4

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

image
image270×718 22.7 KB

5

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 Quick Sight Community Q&A Forum!

6

@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