View Single Post
  #3 (permalink)  
Old April 30th, 2007, 12:14 PM
carswelljr carswelljr is offline
Authorized User
 
Join Date: Aug 2006
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would like to count 5 categories, which will be based on the group_name that has the most values. (eg group_name1 was chosen 10 times, group_name2 was chosen 3 times all for category1, then the image in the cell next to category 1 should be red, because errorcode1 contained the most values for that category.

eg of how the webpage looks:
(5 categories, 5 group_names, 3 images for colorcode)

Ticket_view
Category 1 --> group_name1(10) red
Category 2 --> group_name2 (6) yellow
Category 3 --> group_name3 (5) yellow
Category 4 --> group_name4 (3) green
Category 5 --> group_name5 (1) green

Colortbl.dbo
color -------> green, yellow, red
min_issues --> 1, 3, 5
max_issues --> 3, 5, 999999999


legend:
green - 0-3 errors
yellow - 4-6 errors
red - 7+ errors



Reply With Quote