Grouping Age 1

[robco]

Hello,

I am trying to group the age of cases in my database. The field called "Age" is numeric and can equal 1-150 (in days) depending on the date when a ticket was created.

What I am trying to do is group into 5 categories, <1 day, <3 days and > 1, <5 days and > 3.....etc

I would like to get the count and then put into a graph.
<1 day = 150 cases
< 3 day > 1 = 200 cases etc....

I have tried - if age < 1 then 1......but dont know if that logic will work......and I had a hard time trying to display the other values for a graph.

Any thoughts would be appreciated

Thanks

 

[raja2008]

May be you can crate a formula :
if age<1 then "Less Than 1 day" else
if age<3 then "Less tan 3 days" else
--------for all five of them

Then in group creation use this formula.

Then have a summary field to count the tickets.

Now have a graph on this.

 

[robco]

It worked, thanks!

 

[Charliy]

I do a lot of these type of reports, and to make them come out in a logical order I always use a prefix digit, then use another formula that strips that off to print it.=:

IF {@age} < 1 then "ALess Than One Day"
ELSE
IF {@age} in 1 to 3 then "BOne to Three Days"
...

then group on that formula, but print another formula:
MID({@theotherformuls},2)