4 Replies Latest reply: Jan 12, 2016 1:21 PM by Sangram Reddy RSS

    Yes as percentage of (Yes + No) graphs

      Searched online and seems simple enough, but have come up short.

       

      I am trying to create several gauge graphs from a SQL database.  All of the columns have data that is either "Yes," or "No."  I am looking for most all of my gauges to be a percentage of 'yes'.  In math terms: (count 'yes')/((count "yes") + (count "no"))*100

       

      Table name is Outcomes

      Column name is Nausea

       

      Any help?  Thanks.