This content has been marked as final. Show 2 replies
I have trouble ticket data that comes with an OpenedMonth and a ClosedMonth.
|#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?