I have table that provides an open and a close tickets for a given ticket, and I need to chart it such that I get the # of tickets opened and closed per day. see attached for a quick example.
Can do it with pivoting the table such that it has a TicketId, OpenClose Flag & Date as columns, but am looking for a smarter way so that I don't need to create an intermediate tables.
