# Need Assistance with Displaying Current Rate Metric in Kibana

**URL:** https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190
**Category:** Kibana
**Tags:** lens
**Created:** [October 17, 2023, 10:23am UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190 "2023-10-17T10:23:36Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![Behnam.R](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@Behnam.R](https://discuss.elastic.co/u/Behnam.R)
#### Post date: [October 17, 2023, 10:23am UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/1 "2023-10-17T10:23:36Z")

</div>

I'm using Elasticsearch 8.6 and I've set up a line chart showing the sum of picked items (sum(quantity)) in a project. I've adjusted the chart to display hourly rates, even though Kibana dynamically changes the interval based on the chosen timeframe. I'd like to add another metric to this chart that displays the current rate, which corresponds to the last summed value on the line chart (see the picture below: I want to configure the Gauge to show the last picking rate marked in the linechart). However, I'm struggling to find the right setting in the metrics visualization, such as Goal or Gauge. Can anyone assist me with this?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/1/31db6ff4e73ae0b9080cbab04b5530902d36210f.png)

---

<div class="post-metadata">

### Author: ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)
#### Post date: [October 18, 2023, 1:53am UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/2 "2023-10-18T01:53:00Z")

</div>

Hello @Behnam.R,

I don’t know if I understood the question but you can definitely use a [sum aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/8.10/search-aggregations-metrics-sum-aggregation.html) for the gauge metric.

 ![IMG_2153](https://us1.discourse-cdn.com/elastic/original/3X/8/c/8ca2be16632d668655705400e6fd67281e409126.jpeg)

---

<div class="post-metadata">

### Author: ![Behnam.R](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@Behnam.R](https://discuss.elastic.co/u/Behnam.R)
#### Post date: [October 18, 2023, 12:27pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/3 "2023-10-18T12:27:38Z")

</div>

Thanks for the response @Priscilla_Parodi. I aim to have the Gauge reflect the latest picking rate highlighted on the line chart. in Lens it is possible to select the normalizing option:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cda9e628fcb401b99e4158514e2444d8a86629e7.png)

I want to do the same in the Gauge to normalize the sum aggregation.

---

<div class="post-metadata">

### Author: ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)
#### Post date: [October 18, 2023, 3:51pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/4 "2023-10-18T15:51:41Z")

</div>

@Behnam.R, thanks for the info.

You can do this with Lens... same way but save it to the dashboard.

You open the Dashboard, select the Metrics/ Goal/ Gauge visualization, and click 'Edit Lens', then you edit there (Lens) and save it with the changes.

 ![Screen Shot 2023-10-18 at 11.37.29 AM](https://us1.discourse-cdn.com/elastic/original/3X/d/d/dde423cf2bd6faca1ec25e2fd89d60ffba2afe02.png)

If you don't see 'Edit Lens', you can click on 'Edit visualization' and then you will find it at the top of the page.

 ![Screen Shot 2023-10-18 at 11.48.03 AM](https://us1.discourse-cdn.com/elastic/original/3X/b/e/bee44b2b6755d07bf38c5c8f6d52044e50bcf4b5.png)

---

<div class="post-metadata">

### Author: ![Behnam.R](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@Behnam.R](https://discuss.elastic.co/u/Behnam.R)
#### Post date: [October 18, 2023, 6:19pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/5 "2023-10-18T18:19:01Z")

</div>

@Priscilla_Parodi, does Lens support the speedometer gauge in higher versions? I only see the horizontal and vertical gauge options in my version (8.6.1). These options are also listed under technical preview and have some issues, especially bad render for the segments value and too much blank space on the left side when saved to the dashboard:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/6/36a57417158221d279bb3068e714bbd93b7e039c.png)

---

<div class="post-metadata">

### Author: ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)
#### Post date: [October 18, 2023, 7:03pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/6 "2023-10-18T19:03:42Z")

</div>

> [@Behnam.R](#):
>
> These options are also listed under technical preview and have some issues, especially bad render for the segments value

About the issue, there are some conversations about this:

- [#1188](https://github.com/elastic/elastic-charts/issues/1188)
- [#1235](https://github.com/elastic/elastic-charts/issues/1235)

Note: yes, it is in technical preview.

---

<div class="post-metadata">

### Author: ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)
#### Post date: [October 18, 2023, 7:17pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/7 "2023-10-18T19:17:33Z")

</div>

> [@Behnam.R](#):
>
> does Lens support the speedometer gauge in higher versions?

I don't think we are planning to add full/half circles in Lens.

Depending on the use case you can also consider the metrics visualization.

Another option is to perform a date range aggregation with the timestamp field.

 ![Screen Shot 2023-10-18 at 3.09.31 PM](https://us1.discourse-cdn.com/elastic/original/3X/5/7/577259d8f6a47fd20f99edc6cf91e65e3d91ea52.jpeg)

---

<div class="post-metadata">

### Author: ![Behnam.R](https://avatars.discourse-cdn.com/v4/letter/b/48db29/32.png) [@Behnam.R](https://discuss.elastic.co/u/Behnam.R)
#### Post date: [October 18, 2023, 7:35pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/8 "2023-10-18T19:35:07Z")

</div>

Thank you very much. It appears that this method, i.e., using (now-10m) to adjust the time range and then multiplying the sum value by 6 in the JSON input, may be the only option for me to calculate the current hourly rate and show it in a speedometer

---

<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: [November 15, 2023, 7:36pm UTC](https://discuss.elastic.co/t/need-assistance-with-displaying-current-rate-metric-in-kibana/345190/9 "2023-11-15T19:36:06Z")

</div>

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