Unsolved tickets at beginning of period

Hi,

I am trying to create a monthly report on complaints from the previous month which we will use to populate official reports. One of the queries I am struggling with is "unsolved complaints at beginning of period". Not sure how to timeframe it properly on the query. How would I choose to count the unsolved tickets tagged as complaint at the beginning of the previous month?