The question to always ask here is whether the units that did *not* report have rows in the data (or not). In other words, if someone asking to report on NOT (X), what signifies NOT (X) in the data? (I just added this to the doc that Shawn referenced).
The reason why this is important is that if the answer to units not reporting is that there are no rows in the data, then some sort of padding will be required, and depending on the padding ISNULL() or IFNULL() either will or won't work.
That is the situation Jonathan. These units do not have rows and I'd like to know when they do not have a row.
So the unit reports every single day. If they ever miss a day, I want to know.
Are you guaranteed that at least one other unit will be reporting every day?
There are two routes. One is that you could pad out the data outside of Tableau, for example by having a table of all your units and a table of all dates, using a cross product to make a complete list, then left-joining your reporting data to that list. The other route is to pad the data inside of Tableau, which involves table calculations. If you'd like help putting that together, please provide a packaged workbook with some sample data.
Yes. 100% sure.
That's pretty much what I was thinking but wasn't sure it was the only way.
I'll create a custom sql statement for this.