am working on impromptu and i have a problem . i have a query as below for MAX and MIN :
ALERT MIN: lookup(trim-trailing (cycle type)) in ('AZOPT L'--->499,'BALLM DRY' -->71,'DRY GOODS'-->48,'ECON 4 CAR'--> 752,'econopred'-->718,'otic'--> 1421,'vexol'-->954)default null.
ALERT MAX: lookup(trim-trailing (cycle type)) in ('AZOPT L'--->510,'BALLM DRY' -->85,'DRY GOODS'-->65,'ECON 4 CAR'--> 795,'econopred'-->795,'otic'--> 0,'vexol'-->1034)default null
for the graph reports.
i need to change the MAX and MIN for few EQUIPMENT numbers for FEW CYCLE TYPES like this:
AU-P01 ECONO 4 CAR cycle: ALERT MAX- 805,
AU-PO2 DRY GOODS CYCLE: ALERT MIN- 49,
AU-P11 AZOPT L CARBOY CYCLE: ALERT MIN-499
Can u kindly let me know correct query for MAX and MIN for my Cycle type please.
i have been working on this for a while but am not able to get the correct query. can u kndly let me know the correct query