I have added a tracker view using a date field. I have also added a range using the customization view
It seem to be working fine except when I input a date range and refresh it is pulling some data which appear to have a blank on this date field.
Is the table containing the date one that is joined in the query using an outer join? Because, in that case, I believe it might still keep records with a null date value even if you have a tracker criteria stating a date range.
Then in the Dashboard’s tracker, add a field for “Blank Date”, to MATCH the calc field you added.
Enter:
“Y” to see only results with blank dates
“N” to see only results with non-blank dates (and in the range of your other fields
“B” to see both
If you don’t ever need to see both at the same time. Just make the calc field a boolean