How to Count tickets as DateWise
Posted
by
user560716
on Stack Overflow
See other posts from Stack Overflow
or by user560716
Published on 2011-01-03T00:36:41Z
Indexed on
2011/01/03
0:54 UTC
Read the original article
Hit count: 130
I have a query regarding my report, the report format is as under
**Date** **Received** **Closed** **Pending**
12/01/10 1000 900 100
12/02/10 2000 1000 1000
12/03/10 1500 1300 200
The above report shows the Help Desk tickets Received, Closed, Pending Count as date wise.
How can I create a dynamic SQL query to show above result?
- Received Tickets is calculated on SubmitedDate
- Closed Tickets is calculated on ClosedDate with status "Closed"
- same for Pending Tickets whose status is "Pending".
Please provide me the idea or some sample SQL queries.
© Stack Overflow or respective owner