Report that shows tickets that were Open at the end of every quarter

Hello,

I am tracking tickets/cases in this app and created a separate table to be able to compute our fiscal quarters as we have a 4-4-5 quarter...very different from the Calendar qtr.

I need a graph by fiscal quarter that shows the defect trend. So cases that were in Status 'Open' at the end of every fiscal qtr.  I have the date ticket was opened field 'Activity Logged Date' and a date ticket was closed field 'Closed Date' both of which are related to my Fiscal Calendar table allowing me to pull up the related 'Fiscal Quarter' using those dates. I also have a status field - Open or close.

In summary, I need a graph of tickets that were open at the end of every Fiscal Quarter. How would I achieve this? 

Thanks
Deepa

Thanks