# Comparing two counts - gauge or percentage
**URL:** https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999
**Category:** Kibana
**Created:** [September 4, 2019, 8:11am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999 "2019-09-04T08:11:24Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@goochjs](https://discuss.elastic.co/u/goochjs)
#### Post date: [September 4, 2019, 8:11am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999/1 "2019-09-04T08:11:24Z")
Hi,
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.
J.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [September 6, 2019, 10:48am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999/2 "2019-09-06T10:48:02Z")
You can try with the TSVB (Visual Builder) visualization using the Math aggregations. I think this would be the only way to achieve it.
---
### Author:  [@goochjs](https://discuss.elastic.co/u/goochjs)
#### Post date: [September 6, 2019, 11:51am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999/3 "2019-09-06T11:51:45Z")
Thanks. I'm not familiar with that tool but will look into it.
It'd be better though if gauges could have dynamic limits, based on the count of a filter.
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [September 6, 2019, 11:56am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999/4 "2019-09-06T11:56:03Z")
You can try and use the parameters from the Math aggregation but i'm not really sure they work in TSVB for now. If you can't get the dynamic limits to work, an enhancement request for it would be great here: [https://github.com/elastic/kibana](https://github.com/elastic/kibana)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 4, 2019, 11:56am UTC](https://discuss.elastic.co/t/comparing-two-counts-gauge-or-percentage/197999/5 "2019-10-04T11:56:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.