5 Replies Latest reply: Nov 10, 2011 10:25 AM by Goran Korsgren RSS

    Set Analysis Expression Help

      Hi,

      I need help with a Set Analysis expression.

      I need to count the number of cases where ticket age >7 days. I have a field (Age in days), which gives integer values 1,2,3..8,9, and so on.

      So, basically I want to count(Case Id) where Age in Days >7.

      I'm trying count({$<(AgeinDays >{7})>} CaseID). I know I'm commmitting an error here. Please help.

       

      A second part to this question is if I have two date fields Date A and Date B in mm/dd/yyyy format and if I need to calculate the number of days between these two dates, what would be the expression?

       

       

      Thanks

      AM