• Post Reply Bookmark Topic Watch Topic
  • New Topic

Creating a statistics report with JSP  RSS feed

 
Tony Calvelage
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello everyone. I have a question which will take a bit of explaining so please bear with me.
I am creating a Help Desk call tracker web based application for my company and something has me stumped. What I am trying to do is to create a means of collecting the number of calls per day for each caller, remote location, date and so on.
I want to be able to sum the number of calls for each day and generate a report showing the top ten callers and dates with the most calls.
I would classify myself as a novice when it comes to java so I am unable to work something out for tackling this problem.
The calls are stored as tickets in a database with fields for Callers, IT Systems, Locations and dates reported, among others.
Can anyone suggest some documentation or tutorials which could shed some light on this issue? I've been unable to find anything reliable on line and all the books I have read through cover pretty basic stuff. I would appreciate any help you can give. Thanks.
 
Yan Lee
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Tony:
One solution could be.
1. Have a column in the table that stores the number of times a user accessess the help desk
2. Every time the user uses the system, increment the count by 1
3. When ever you want to generate a report, use a SQL statement
SELECT * FROM CallHistory
ORDER BY UserId
4. You can take the first 10 entries of the returned rowset
Hope this works.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!