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

# 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.

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

• ###### Set Analysis Expression Help

something like this i think:

count({<AgeinDays={">7"}>} CaseID)

hth /gg

• ###### Set Analysis Expression Help

Hi AM

/gg

• ###### Re: Set Analysis Expression Help

Hi GG,

I was making a small mistake on my end. The expression worked. But I want to ask an extension to this question.

I now know that for comparing with > I need to use = (">"). But what is the operator for not equal. e.g.

if I wanted to see count of all caseID  where Age in Days is not equal to 7 days.

I tried <> and even != but it did not work.

Thanks

AM

• ###### Re: Set Analysis Expression Help

If you want all which is not equal to 7 days in Set analysis:

{<AgeinDays-={"7"}>}

hth

/gg

• ###### Set Analysis Expression Help

For subtracting dates I would try

DateA-DateB

/gg