1 Reply Latest reply: Apr 8, 2015 6:05 PM by Rod Jager RSS

    Set gauge value based on expression with where clause

    Jason Jakob

      I have an excel dataset with location and value

       

      Location, Value

      Oven1, 101

      Oven2, 150

      Oven3, 125

       

      I want to have a gauge for each location.

       

      for the first guage:

       

      Current = Value where Location = 'Oven1'

       

      for the second guage:

       

      Current = Value where Location = 'Oven2'

       

      How do I do this with a non aggregate expression?