4 Replies Latest reply: Mar 1, 2015 8:32 PM by Jim Chan RSS

    Need to filter 2 field names to get a result, how to write this expression?

    Jim Chan

      Hi guys, i want to write an expression. but i always hit the error.

      I would like to write an expression about - how many "Incident" tickets are at "Open" status.

      DescriptionStat_Desc
      IncidentOpen
      IncidentOpen
      Change RequestOn Hold

       

      I have tried writing the expression as such count({<[Sta_Desc] = {'Open'}>} Total Description), but i do not know how to filter the Description = Incident.

       

      Please advice.