Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Get 'or' into Gauge Expression

Hello Everyone,

I've got a Gauge, and I need to have an 'Or' statement evaluated.  But for the life of me I can't figure out how to do it.  My statement looks like so, and it errors out no matter what:

(

   COUNT({<isDelivery={'1'},

    OutofGracePeriod={'1'},

    ([Destination Point] = {'Miami'} or [Origin Point] = {'Charlotte'} )

    >}

  [Flight Number]

)

Any help on this rookie issue would be greatly appreciated.

3 Replies
sunny_talwar

Try this

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>+<isDelivery={'1'}, OutofGracePeriod={'1'}, [Origin Point] = {'Charlotte'}>} [Flight Number])

sunny_talwar

or not sure, but try this as well

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}>*(<[Destination Point] = {'Miami'}>+<[Origin Point] = {'Charlotte'}>)} [Flight Number])

Anonymous
Not applicable

Or maybe?

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>[Flight Number]) +

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Charlotte'}>[Flight Number])