OK,
Date range is the termination date or last day with that job title (got promotion) but for currently employees in current position this is NULL.
I got a null replacement of “Current Position” (because it showing job title changes).
How can I filter for the NULL ("Unknown’) value, I want to see all current employees in their current positions.
Your best bet is probably to create a calculated element and translate those nulls into something that can be filtered like a boolean or string right on the dashboard. You wouldn’t be able to use the calendar picker to select these values but a complimentary filter control would do the trick.
That is what I did and it works. I just got stuck earlier on the other not possible way, had to walk away from it to think clearly on a solution.
I was wrestling with that just today… and came to the same conclusion. Needless to say, that is disappointing.
FWIW: You could use a null replacement in your data cube construction and replace nulls with a “missing value” flag, then filter out those, but incurs it’s own set of maintenance risks.
I needed the nulls to be there, that means the person is still employed.
In the metric set I do a replacement of UNK to a string “Currently Position”.
Can not do data cube null replacement because you have to put a date in there, and no date make scene. current date would just be confusing.
Thanks for the feedback everyone. I’ve shared your comments with the development team and we’ll certainly see if there is anything that can be done to help with the ease of use here in the future.
Hi - What I’ve seen is that “Null” is a filtering option in the token menu for dates when you use a Single Date filter (but not if you replaced the dates with a time dimension - presumably because there are no nulls anymore but unknown members.)
By any chance, can you share the formula utilized in this case? I’m struggling with a similar scenario, where I need to filter out the fields that have a “Deleted on” date.
@gerardo.cebollero
I had to remember what Dashboard this was an issue on. once I did I was OH NO not this one.
internal politics, reasons.
I got into the metric set and did null replacement on date to show Current Position.
to filter out current employees you leave the date range filter to open bound range or all for the TO field. setting an actual date in the “TO” filters out the null values that are being replace with “Current Position”
Thanks! I managed to sort it out. I did
IF ($name_of_field$ == null) {return “False”;}
else return “True”;
I just get confused about the language needed specifically in Dundas especially since I’m not a programmer or a data analyst so it’s not necessarily on the top of my mind.
oh you wanted Jeff script. 
yeah that works, i might have even done that, i just read my comments and quickly look at the dashboard that not being used to see what I did.
It has been a minute on this one.