Tickets analysis in a month

Hi ,
we want to create a new eaZyBI dashboard with the following data

For a given time period (Month)

  1. No of tickets at the start of the month (open tickets)
  2. No of tickets created in the month
  3. No of tickets resolved in the month
  4. Pending open tickets at the end of the month