# Graphana + ElasticSearch : Percentage in DashBoard

**URL:** <https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357>\
**Category:** Grafana Plugin Development\
**Created:** [September 11, 2018, 4:30pm UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357 "2018-09-11T16:30:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilietto](https://avatars.discourse-cdn.com/v4/letter/i/34f0e0/32.png) [@ilietto](https://community.grafana.com/u/ilietto)\
**Post date:** [September 11, 2018, 4:30pm UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357/1 "2018-09-11T16:30:42Z")

</div>

urgent! I work with GRAFANA and ElasticSearch. I need to display in my dashboard the percentage of success activations related all activations requests in one month.  
is there a formula to apply to the metrics to calculate this KPI?  
is there any trick to overcome this problem?  
very, very tnks  
ILIO

---

<div class="post-metadata">

**Author:** ![tfischer330](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@tfischer330](https://community.grafana.com/u/tfischer330)\
**Post date:** [September 13, 2018, 6:04pm UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357/2 "2018-09-13T18:04:20Z")

</div>

I don’t have any experience with Elastisearch, but maybe this could help you out:

> **[Query to calculate successrate](https://discuss.elastic.co/t/query-to-calculate-successrate/98886/9)**
>
> One more thing, Is this kind of query possible to visualize in kibana? If so how? Thanks Mathias

---

<div class="post-metadata">

**Author:** ![anon34853223](https://avatars.discourse-cdn.com/v4/letter/a/71c47a/32.png) [@anon34853223](https://community.grafana.com/u/anon34853223)\
**Post date:** [September 21, 2018, 12:39pm UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357/3 "2018-09-21T12:39:00Z")

</div>

[MetaQueries plugin](https://grafana.com/plugins/goshposh-metaqueries-datasource) should be able to help you with this

---

<div class="post-metadata">

**Author:** ![fajar3t3](https://avatars.discourse-cdn.com/v4/letter/f/5daacb/32.png) [@fajar3t3](https://community.grafana.com/u/fajar3t3)\
**Post date:** [February 16, 2020, 11:53pm UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357/4 "2020-02-16T23:53:05Z")

</div>

hi @anon34853223

i’m trying with metaqueries but cant display value percentage result.

---

<div class="post-metadata">

**Author:** ![shashidtj](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@shashidtj](https://community.grafana.com/u/shashidtj)\
**Post date:** [October 23, 2020, 7:41am UTC](https://community.grafana.com/t/graphana-elasticsearch-percentage-in-dashboard/10357/5 "2020-10-23T07:41:16Z")

</div>

Hi @ilietto, do let us know if you found the answer.