Select Statemant

[Butlertl]

I have a field, "TITLE" that can have one of 5 different titles...the problem is that "Call Center, Response to Service, Silver" can be entered for the same ticket number several times.....I need to select the record for the first entry.......the date it was entered is not available.....any ideas?

Thanks again

Terry

 

[hilfy]

Since there's no date, unless there is some sort of sequence number to indicate which title is "first", there is no way to do this.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Madawc]

You could group by Title, show details in the group header and suppress the detail lines.

This would have to happen on records you've already selected. Selection rules for Crystal can only be based on the properties of individual records. (You can do more with a Stored Procedure, when your system allows this.)

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[Butlertl]

The fields would be "Call Center, Response to Service, Silver" and the next Field would be "MET" or "MISSED".....I need to count the number missed but would need to count the first instance.....is that possible?

 

[Butlertl]

INC000000019497
Call Center, Response to Service, Silver Met
Call Center, Response to Service, Silver Missed
Call Center, Response to Service, Silver Met
Call Center, Response to Service, Silver Missed

In this example I would want to count the first "MET" and ignore the remaining entries

Thanks

 

[lbass]

Is this really about selecting or counting? Your last two posts are confusing. In one you say you need to count "missed" and in the other, "met". Which is it?

Why is counting the "first" instance important? Do you really just need to count which IDs contain a record that contains "met"? (Or is it "missed"?)

-LB

 

[Butlertl]

It is either a select or counting....If I cannot select the records I need without multiple then I need to count just the first entry in the list.......

 

[lbass]

Please spend some time responding completely to questions.

-LB

 

[Butlertl]

CR 10.

I need a report for all tickets closed and determine the percentage of tickets that meet the metric.

SVTTitle = "Response to Service, Silver" or "Response to Service, Gold", or "Response to Service, Platinum"

MeasurementStatus = "Missed" or Met"

The problem: A new version of Remedy is logging more than on Date/Time for "Response To Service...." when we should have but one entry for the Response Date/Time.
We can have:
"Response To Service, Silver" "Met"
"Response To Service, Silver" "Missed"


While awaiting a fix to Remedy.....I need to select the first Response entry or if not possible then just count the first Response entry and ignore the remaining entries...

 

[lbass]

That's better, but please clarify:

What fields you are grouping on?

Are you looking for the percent of tickets that have at least one of two codes (missing, met) per some group? Which group?

-LB

 

[Butlertl]

This is my select statement
{844_Helpdesk_to_SLA_measurement.Last Resolved Date} in {?Date Range} and
{844_Helpdesk_to_SLA_measurement.Status} in ["Resolved", "Closed"] and
not {@Exclude} and
not ({844_Helpdesk_to_SLA_measurement.Assigned Group} in ["Secure Voice"]) and
{844_Helpdesk_to_SLA_measurement.Contact Sensitivity} in ["Silver"] and
{844_Helpdesk_to_SLA_measurement.MetricExempt} in ["No"]

I have a grouping on Incident Number (Ticket Number).

Looking for the percentage of tickets that passed the metric or "MET".

 

[lbass]

So you are looking for a report level percentage, I guess.

Create a formula {@Met} like this:

if {844_Helpdesk_to_SLA_measurement.measurementstatus} = "MET" then
{844_Helpdesk_to_SLA_measurement.incidentnumber} else
{@null}

{@null} is a formula that you should create by opening and saving a new formula without entering anything. Replace the two fields with actual field names. Also, make sure "MET" reflects the case used in the database.

You should then be able to use a formula like this for the percentage:

distinctcount({@Met})%distinctcount({844_Helpdesk_to_SLA_measurement.incidentnumber})

-LB