# Gauge vusualization **URL:** \ **Category:** Kibana\ **Created:** [May 13, 2021, 1:12pm UTC](https://discuss.elastic.co/t/gauge-vusualization/272912 "2021-05-13T13:12:45Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![DivinLobo](https://avatars.discourse-cdn.com/v4/letter/d/73ab20/32.png) [@DivinLobo](https://discuss.elastic.co/u/DivinLobo)\ **Post date:** [May 13, 2021, 1:12pm UTC](https://discuss.elastic.co/t/gauge-vusualization/272912/1 "2021-05-13T13:12:45Z")
I've recently started trying out Elasticsearch and Kibana and I am trying out the Gauge graph ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/25875dd0f7d13d856eeab1eea2ed28a9b40d12d5.png) I am taking the average value of a field and set up the custom ranges like so. ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/d/9da5d3c23b268a8dc797f121fe0b67cdce7d5ef3.png) I would Like to Know if it is possible to replace the displayed Number i.e. in this case "70" with a letter grade instead of the number itself. e.g. the average value is 70 so the displayed letter should be D i.e Assigning a letter to a range instead of a specific Number. 0 - 40 = A 40 - 45 = B and so on Can anyone provide a solution to My Problem. ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [May 14, 2021, 12:04am UTC](https://discuss.elastic.co/t/gauge-vusualization/272912/2 "2021-05-14T00:04:58Z")
Hi @DivinLobo. I don't think this is possible in Kibana. However, the gauge in the TSVB visualization can change the color of the bar and text label based on results. I realize that's not exactly what you are looking for though. ![Screenshot_2021-05-13 Gauge test - Elastic(1)](https://us1.discourse-cdn.com/elastic/original/3X/b/2/b2567072e640db52c7f5b430868e9149c294c956.png) You may wish to [open a feature request](https://github.com/elastic/kibana/issues/new?assignees=&labels=&template=Feature_request.md). ---
**Author:** ![DivinLobo](https://avatars.discourse-cdn.com/v4/letter/d/73ab20/32.png) [@DivinLobo](https://discuss.elastic.co/u/DivinLobo)\ **Post date:** [May 14, 2021, 12:10pm UTC](https://discuss.elastic.co/t/gauge-vusualization/272912/3 "2021-05-14T12:10:39Z")
Thank you for the Reply But my visualization does not necessarily need to be a Gauge I primarily need to display the final average as a letter grade. Is there any visualization that can fulfill this requirement? Any visualization will do. Even something like a Metric that would just display a single letter. ---
**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\ **Post date:** [May 18, 2021, 10:12pm UTC](https://discuss.elastic.co/t/gauge-vusualization/272912/4 "2021-05-18T22:12:46Z")
Hi @DivinLobo. One way to do this is with Canvas. In the screenshot below, I added a table visualization to my Canvas workpad and applied a [switch function](https://www.elastic.co/guide/en/kibana/current/canvas-function-reference.html#switch_fn) to generate a new `grade` column based on the values of the `percent_uptime` column. ![Screen Shot 2021-05-19 at 15.07.50](https://us1.discourse-cdn.com/elastic/original/3X/d/a/daecb8cc34d789ad706c1fe71408ac96b2809263.png) In your case, you'll need to get data for the visualization using an Elasticsearch SQL query to average the field value then modify the expression similar to what I did in the screenshot. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 15, 2021, 10:13pm UTC](https://discuss.elastic.co/t/gauge-vusualization/272912/5 "2021-06-15T22:13:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.