You could accomplish all of those things with IF statements in new calculated fields. For instance:
-Null Count=SUM(IF ISNULL([Field Name]) THEN 1 ELSE 0 END)
-Row Count=SUM([Number of Records])
-Special Characters=SUM(IF CONTAINS([Field Name], "character" ) THEN 1 ELSE 0 END)
-Dates Out of Range=SUM(IF [Date]>=DATE("2016-12-31") THEN 1 ELSE 0 END)
I've done some experimenting with the COUNT function and I do feel that is the way to go for now.
I was wanting to know the values that do not match my criteria and display that on a Dashboard. Any thoughts on that?
Yeah! You could make an IF statement that categorizes values as either "Match" or "No Match" based on the criteria you specify and then use it as a filter.
Ah! okay so it would be like:
IF SUM(IF ISNULL([Field Name]) THEN 1 ELSE 0 END) = 1 THEN Match ELSE No Match END
and filter for "Match"?
I'll experiment with that.
You could even simplify that further by writing:
IF ISNULL([Field Name]) THEN "Match" ELSE "No Match" END
Note that when you want the output to be a text string you need to include quotation marks. Also, you can include more criteria using ELSEIF, AND, OR operators.