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"

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.

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