We've got two metrics which we would like to compare. One is a count of total work items due for a day. This builds up as hundreds of thousands of events are received during the morning. Let's call the count of these totA.
Over the entire day, we receive a different set of events into the same index, which denote each work item being actioned. Let's call the count of these totB.
I want to show a comparison between these on a dashboard. Ideally this would be a gauge, measuring totB but with maximum range set as totA.
Alternatively, I'll settle for showing a metric, calculated as totB / totA as a %age.
But I can't work out how to do either!
Suggestions gratefully received, thanks.