To analyse how many issues were in certain status at the end of each period you should use data from issue change history. In the report use measure Issues history together with dimension Transition Status and Time to represent issue status at the end of the selected date.
You may check out report example “History of unresolved issue statuses” in eazyBI Demo account: