# Gauge/Goal visulation - divide two counts

**URL:** https://discuss.elastic.co/t/gauge-goal-visulation-divide-two-counts/190794
**Category:** Kibana
**Created:** [July 16, 2019, 4:48pm UTC](https://discuss.elastic.co/t/gauge-goal-visulation-divide-two-counts/190794 "2019-07-16T16:48:47Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Jorge\_Pereira](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jorge_pereira/32/50275_2.png) [@Jorge\_Pereira](https://discuss.elastic.co/u/Jorge_Pereira)
#### Post date: [July 16, 2019, 4:48pm UTC](https://discuss.elastic.co/t/gauge-goal-visulation-divide-two-counts/190794/1 "2019-07-16T16:48:47Z")

</div>

Hello,

I'm trying to make a gauge/goal visualization that shows the percentage of successful requests (success / total).

So far I managed to make a visualization with timelion that has an approximated result using the following expression :

```
    .es(index=index, timefield='@timestamp', metric='count', 
q='status : "success"').divide(.es(index=index, timefield='timestamp', metric='count')) 

```

Now i'm trying to have a visualization that shows this overall ratio. I tried using time builder with a filter ratio but is giving me an error of Maximum buckets exceeded and I'm afraid to change this value since I'm looking to a big amount of data. I also tried using a pie chart but this doesn't allow me to set a specific color when the ratio is lesser than a value, like the gauge does.

Would appreciate any suggestion.

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [July 18, 2019, 1:14pm UTC](https://discuss.elastic.co/t/gauge-goal-visulation-divide-two-counts/190794/2 "2019-07-18T13:14:19Z")

</div>

Depending on what version of Kibana you're using, you could try doing this in the Visual Builder visualization. It has a goal option and more settings you can customize.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 15, 2019, 1:14pm UTC](https://discuss.elastic.co/t/gauge-goal-visulation-divide-two-counts/190794/3 "2019-08-15T13:14:25Z")

</div>

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