# Goals/Guages with irregular values
**URL:** https://discuss.elastic.co/t/goals-guages-with-irregular-values/181636
**Category:** Kibana
**Created:** [May 17, 2019, 6:46pm UTC](https://discuss.elastic.co/t/goals-guages-with-irregular-values/181636 "2019-05-17T18:46:08Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@david-cunningham-rez](https://discuss.elastic.co/u/david-cunningham-rez)
#### Post date: [May 17, 2019, 6:46pm UTC](https://discuss.elastic.co/t/goals-guages-with-irregular-values/181636/1 "2019-05-17T18:46:08Z")
So my company is currently capturing number of automated tests and number of manual tests as a field in the documents by project each month. We want to see the percentage automation of automated tests we for the entire company for the current month. So to calculate this percentage I would need to do the following:
AutomationPecentage = SUM(Automated)/(SUM(Automated)+SUM(Manual)).
We would like to display this as a goal (say 80% automation). However, I'm not seeing a great way to display that in kibana.
I can't make the goal range based on a field (so I can't just create a scripted field "total" and then Sum aggregate automated) as far as I know.
If I could calculate the percentage in the visualization I could just set my range from 0 - 100 and be fine, but I'm not really sure how to do that. I can't really accomplish this as a scripted field because I would need to know the total (which is an aggregation of the values in my documents)
Can somebody help me with this? I'm pretty new to Kibana.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [May 27, 2019, 2:19pm UTC](https://discuss.elastic.co/t/goals-guages-with-irregular-values/181636/2 "2019-05-27T14:19:48Z")
Interesting problem. I am not sure if we have a way to do this now. @lukeelmers can we please get some help here?
Thanks,
Bhavya
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 24, 2019, 2:19pm UTC](https://discuss.elastic.co/t/goals-guages-with-irregular-values/181636/3 "2019-06-24T14:19:55Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.