Snapshot of data

Snapshot of data

I use Zoho Analytics and Zoho Desk. I have my data fro Zoho Desk refresh into Analytics daily. 

I wanted to be able to produce some reports that will show me the backlog of tickets per month historically. So i can see on the last day of the month, per month what the backlog was at.

e.g.

Jan 100
Feb 200
March 300
Apr 300
May 200
June 250

Any one know how you can do this?