The Data I'm working with is
INC# Client Summary Opened Date Closed Date
1 user A Issue 1 12/18/2006 07/03/2015
2 user B Issue 2 04/01/2015 07/02/2015
3 user C Issue 3 05/04/2015 05/06/2015
I want to run a report that will show me how many open tickets were in our queue at the end of each month. I need a formula to answer the question "was this ticket still open on April 30th 2015" then show a count
Right now I'm pulling all the tickets we have from Track-IT! 9 have and just done some filtering out of subTickets in Crystal reports XI.
This sql script may help