I'm trying to get data on the number of problems we have open on a given day/month whatever. but I"m completely stumped I know how to query the db if the problem happened during this month or last month, but what I really want is the total number of problems divided out by the months they happened.
e.g.
TableName: problem
id start_date
1 01/12/03
2 01/08/03
3 02/12/03
4 01/04/04
QueryName: perfectQuery
1/03 2
2/03 1
1/04 1
Ideas?
e.g.
TableName: problem
id start_date
1 01/12/03
2 01/08/03
3 02/12/03
4 01/04/04
QueryName: perfectQuery
1/03 2
2/03 1
1/04 1
Ideas?
