# Is there a way to get " count of records, with Status = 'closed' of previous month DIVIDED BY count of records, with status = 'New' of current month"
**URL:** https://discuss.elastic.co/t/is-there-a-way-to-get-count-of-records-with-status-closed-of-previous-month-divided-by-count-of-records-with-status-new-of-current-month/250163
**Category:** Kibana
**Created:** [September 28, 2020, 9:57am UTC](https://discuss.elastic.co/t/is-there-a-way-to-get-count-of-records-with-status-closed-of-previous-month-divided-by-count-of-records-with-status-new-of-current-month/250163 "2020-09-28T09:57:53Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Pooja](https://discuss.elastic.co/u/Pooja)
#### Post date: [September 28, 2020, 9:57am UTC](https://discuss.elastic.co/t/is-there-a-way-to-get-count-of-records-with-status-closed-of-previous-month-divided-by-count-of-records-with-status-new-of-current-month/250163/1 "2020-09-28T09:57:53Z")
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)
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [October 5, 2020, 5:46pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-get-count-of-records-with-status-closed-of-previous-month-divided-by-count-of-records-with-status-new-of-current-month/250163/2 "2020-10-05T17:46:31Z")
I suggest using TSVB and the Math aggregation, that will allow you to do advanced bucket math like this.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 2, 2020, 5:46pm UTC](https://discuss.elastic.co/t/is-there-a-way-to-get-count-of-records-with-status-closed-of-previous-month-divided-by-count-of-records-with-status-new-of-current-month/250163/3 "2020-11-02T17:46:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.