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"

Elastic Stack Kibana
1

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)

2

I suggest using TSVB and the Math aggregation, that will allow you to do advanced bucket math like this.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.