1 2 Previous Next 18 Replies Latest reply on Jan 10, 2014 2:02 PM by Matt Lutton

    How to create a % of total for a certain measure's value and then filter on it

    Jason Wilson

      I cannot seem to figure out how to do this.  Seems fairly simple though.  I am trying to create a network health report.  I have a query that returns a list of all my networks, the items in my networks with a status column.  The status column column can have a value of "Good", "Bad" or "Watch".  I need to create a report that show a list of my networks, with their current health stat.  The health stat is calculated as [# of records where status = "Good"] / [# of total records (all status types)]. 

       

      I then want to be able to filter on this health stat value to show only networks with say a health stat of < 95% or put those on a heat map and color those networks red.

       

      I have tried to figure out how to do this with table calculations, but cannot seem to figure out how to accomplish what I need.

       

      Jason

        1 2 Previous Next