We have a table which has request created time,Request closed time ,status everything in the same table.
We want a kind of trend report which should display for duration the closed and Open count. For ex the grpah should display Jan month 20 closed tickets and 10 open tickets similary for the other months.
Do i need to create the calender control seprately irrespective of the Requested Created time and closed time and use the same to get the graph or is there any other way.
Since the Ticket might have raised on Jan month and closed on Feb month. The ticket should contribute to open count in Jan Month and same ticket should contribute to Closed count in Feb month.
