Hi everyone,
I have trouble ticket data that comes with an OpenedMonth and a ClosedMonth.
TicketNumber
| OpenedMonth
| ClosedMonth | CountOfTickets |
|---|
| #1 | Feb 2012 | May 2012 | 1 |
| #2 | Mar 2012 | Mar 2012 | 1 |
| #3 | Mar 2012 | Apr 2012 | 1 |
| #4 | Apr 2012 | Apr 2012 | 1 |
| #5 | Apr 2012 | May 2012 | 1 |
| #6 | May 2012 | May 2012 | 1 |
I want the user to be able to select a Month and Year, and be able to see a backlog of tickets for that month and year.
For example, In Apr 2012, tickets #1 and #5 were available at some point during Apr 2012, but were not resolved until May 2012.
So I want tickets with OpenMonth <= SelectedMonth AND ClosedMonth > SelectedMonth
The SelectedMonth isn't really an OpenMonth or a ClosedMonth.. if I create a list of every month and year, how do I select backlog tickets for selected dates?
I'm guessing a straight or pivot chart with set analysis would be best? What would the expression have to look like?
Thank you!
