
August 25th, 2004, 10:51 AM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Call Activity by Equipment Type in Percent
Not sure how to ask this but I need help developing a query that will give me the following information:: Number of
incidents, type of equipment incident was from and display this information as a percentage.
The table names are IncidentID, EQUIPMENT_TYPE_NAME_NV, NumEvents, and HoursOpen
This is from a pie chart that is broken into five pieces. LaserB/W, Laser Color, MFD-copyprint, Fax, and Inkjet Color.
Thbe chart is depicting the IncidentID as a percentage.
The query I am using is:
Select IncidentID, EQUIPMENT_TYPE_NAME_NV, NumEvents, HoursOpen
from DW_Incident_V I
where CustomerCompanyID = 1 and
DateCreated >= '01/01/2000' and
DateCreated <= '08/01/2004' and Model_NV is not null
group by I.IncidentID, I.Equipment_Type_Name_NV, I.NumEvents, I.HoursOpen
but...it only gives me collumns: IncidentID, Equipment_Type_Name_NV, and NumEvents
I know this is kind of off the wall but I thought I'd give you all a chance at it anyway. If you need any more info feel free to ask.
TIA, Frogger
|