3 Replies Latest reply on Jul 27, 2016 5:09 AM by Ashish Chaudhari

    Overall Health Calculation against 5 checks

    Tony Ball

      Hi All,


      I wondered if you could help with this one?


      I've built a dashboard which does some Yes/No checks on some services at work. I've currently got 5 checks running which you can see in screenshot below.


      I have been trying to roll up the percentages from these 5 checks to produce another panel which would display an overall heath in a percentage score.


      So for example in the Red panels (No) I have percentage scores of 19.85 + 1.70 + 25.88 + 76.22 + 5.59. Which would = 129.24 then divide by the 5 checks = 25.84% Same for the Green (Yes) which would = 74.16%.


      The only problem is that I don't know how to achieve this in Tableau? To make matters a bit more complicated the SQL query I've used to build the dashboard is a series of Unions doing checks against each area and the item being counted on is a string and not integer.  - I'm not sure if this is affecting any calculation attempts?


      I've attached a workbook to this post too - if anyone can provide any sort of help it would be greatly appreciated.