AnsweredAssumed Answered

RED GREEN BLUE Totals

Question asked by gldiaz on May 9, 2013
Latest reply on May 9, 2013 by philmodjunk

Title

RED GREEN BLUE Totals

Post

     I'm hoping for a little input and I'm not sure how to do this..

     We deal and inspect convience stores. This question is relative to tracking gas pumps.
     Here's what I'm hoping for:

     1. From a Table View or Portal.
         Each pump is rated on a point system 1-10.  (1 is low concern and 10 very High Concern / Needing attention)
          i.e.

                  LOCATIONS                                                           Concern TOTALS                              # Inspected     TOTAL

     Store#1  Chevon  Convience, Addr, Ph               RED###, ORANGE ###, Blue###, White###           x                 xxx
     Store#2  Shell #2 Convience, Addr, Ph               RED###, ORANGE ###, Blue###, White###          None            xxx
     Store#3  Texaco  Convience, Addr, Ph               RED###, ORANGE ###, Blue###, White###           xx                xxx 

     As we review the selected store, we would like to "Drill down to the details for each chosen store".
     Some stores have from 4 to as many as 24 gas pumps.

      Any thoughts on getting the totals in the DOTS within a Portal or Table  showing the  " # Concerns ".

     Hope this is clear enough.

     Tks

     Gil

      

      

      

      

Outcomes