Category Selector Filter

[ClaireC]

Hello, 

I have recently created a dashboard to monitor our organisation's assets which are inspected using Field Maps. 

The dashboard is working off a view of the main dataset, that is joined with the latest inspection from the related inspections table. 

During an inspection an asset can be flagged for maintenance required. Once this maintenance is completed, the inspection record is updated and a date for maintenance completed is entered. 

I have a category selector on my dashboard that should be showing assets with outstanding maintenance only by filtering out where 'Date Maintenance Completed' is null. However, assets with maintenance completed are still coming through. 

There are 3 AND statements in my filter so I would expect anything that has a non-null maintenance completed date to be dropped. 

Is there something I am overlooking? Any pointers are greatly appreciated. 

Many thanks, 

Claire

[PatMannix]

Any Community Support help on this would be appreciated.

[CharmaleeSandanayake1]

I was trying something similar and I found that the null filter you are trying only filters the available choices in the Category field based on the filtered data, not the data itself. The data itself is filtered by the category selector choices and the Actions. Unfortunately I think what you are trying to do may not be possible, but there is an ArcGIS Idea you can vote on: https://community.esri.com/t5/arcgis-dashboards-ideas/add-null-override-category-to-selector/idi-p/1...