Hi Chrissy, you may need to pad your original data with outage rows for every service/month combination setting [_Service Minutes Degraded] to 0 or NULL. Since Tableau will not create new rows of data for you, just adding ZN won't work, because there's no field to check for NULL. If you do use NULL for your padded rows, you will need to use ZN.
Hi Zach, thanks for your response. How do I get Tableau to pad my data?
To pad your data, you can either insert the dummy rows into your database or spreadsheet before bringing the data into Tableau, or you can use Tableau Custom SQL to read your data plus UNION ALL some additional rows. You can search the forums for examples. It could be tedious to maintain.
Another approach is to invert your reporting, and show total downtime, not percent uptime. Then periods with no downtime will correctly show nothing. A lot of your calculations would be much simpler. I know that as a customer of this type of information, hearing 99.9% uptime means nothing to me, it's much more informative to know we had 6 hours of downtime last quarter. It's also much easier to visually and numerically compare 6 hours vs. 12 hours than it is to compare 99.9% with 99.7%.
The straight forward solution is modify the data source as already communicated.
However, here is brain-teaser type of info.
This requires the Service selection by "parameter" not filter though.
FYI : Here is relatively similar thread.
Availabiltiy Question_SM_10.0.twbx 427.8 KB
THIS IS GENIUS!
I have absolutely no idea how this is working but I got it replicated in my workbook and it's awesome. Thank you!
If you have a few minutes to spare, can you explain to me what each of those calculated fields is doing?
Again, thanks a ton. This is my new coolest-thing-in-Tableau
Glad to help you, but as I said, this is kind of brain-teaser type of thing and it requires several hours to explain all the background.
I don't have time now and also it's difficult to promise when. I will keep this in mind, though.
Sorry for inconvenience.