Categorising Logged and Closed Data

[69AceCool]

Hi All,

Using CRXI
ODBC Connection to Remedy ARS 5.1

Query is:

{Data.Logged_Date} = {?DateRange}
or
{Data.Closed_Date} = {?DateRange}

This retrieves anything logged or closed over the selected date period.

What I am now trying to do is count them correctly. There are 3 'states' (as far as I can tell) that the calls can be in:
S1) Calls logged within the date range but not closed.
S2) Calls logged and closed within the date range.
S3) Calls closed within the date range.

Say we retrieved the following number of records within the states described above:

S1 = 3
S2 = 2
S3 = 4

This would give a result of
Logged Closed
S1 3 0
S2 2 2
S3 0 4
Total 5 6

I would only want to show the final Logged and Closed figures not the states in between.

Thanks in advance!

 

[lbass]

If you only need the final results, e.g., 5 and 6 in your example above, then try creating two formulas:

//{@logged}:
if {Data.Logged_Date} = {?DateRange} then 1

//{@closed}:
if {Data.Closed_Date} = {?DateRange} then 1

Then place these in the detail section and right click and insert summaries on them.

-LB

 

[69AceCool]

Thanks lbass !