I have a data set that consists of metrics about MQ Channel Counts by channel. I think I can use visual builder to display the percentage of connections used per channel. I'm stuck on how to accomplish this.
In ES, I have a new document for every connection.
So the count of documents by Channel Name gives me the current connections for any given channel. However, each channel can be configured for a different maximum. The max connections value is recorded with every document above.
Do you have an idea how I can calculate this in a single percentage metric to display with the guage?
Logically like this,
For Each Channel
Average Doc count / MAX max_conns = percentage used