I would like to get the following value to be populated on my dashboard.
(Count of records, whose status: 'Closed', month : @timestamp - 1month) / (Count of records, whose status: 'New', month: @timestamp)
I suggest using TSVB and the Math aggregation, that will allow you to do advanced bucket math like this.