Are you wanting a count of currently open tickets by day?
So if you have the following tickets.
Ticket Created Date Solved Date
1 2018-06-01 2016-06-05
2 2018-06-03 2016-06-07
You would get the counts for each day of
2016-06-05 1 or 2 depending on how you want to count solved date
I think that this is completely different thing, but anyway how you are going to add every single date, or you will use only the dates from created at?
Thank you very much! This solved my problem perfectly! I have never used Pivot before, it is very useful. Thanks again!