# Kibana dashboard values changing indicators

**URL:** https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734
**Category:** Kibana
**Tags:** dashboard
**Created:** [February 7, 2024, 10:28am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734 "2024-02-07T10:28:13Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![SamehSaeed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samehsaeed/32/145262_2.png) [@SamehSaeed](https://discuss.elastic.co/u/SamehSaeed)
#### Post date: [February 7, 2024, 10:28am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/1 "2024-02-07T10:28:13Z")

</div>

Hello, I have a dashboard with a "table" panel (lens) which have over 100 rows, each with count of success and failure for each row (service).  
How can i add an indicator in that can show whether these values have changed over the last 5-10 minutes? like an up arrow or change color of text to green for example. We are monitoring values of a whole day so it's hard to memorize all values to know if it's changing or not.

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

---

<div class="post-metadata">

### Author: ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [February 8, 2024, 11:59am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/2 "2024-02-08T11:59:14Z")

</div>

Hi @SamehSaeed,

I'm not aware of a way to change the update style within Kibana itself. I have a feeling you would need to change the CSS yourself or consider writing a plugin.

---

<div class="post-metadata">

### Author: ![SamehSaeed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samehsaeed/32/145262_2.png) [@SamehSaeed](https://discuss.elastic.co/u/SamehSaeed)
#### Post date: [February 12, 2024, 6:25am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/3 "2024-02-12T06:25:10Z")

</div>

Thanks for your reply, using a plugin might work but how do i calculate that there was a difference in this value over the last 5 minutes? I tried to make a runtime field like Final Status -5 which should hold the count but 5 minutes before (Final Status is also a runtime field) but I couldn't make it work.

---

<div class="post-metadata">

### Author: ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [February 12, 2024, 9:23am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/4 "2024-02-12T09:23:14Z")

</div>

Can you give more details on the runtime field calculation you had, and what you mean by "it didn't work"? Were you receiving a particular error or just an unexpected result?

---

<div class="post-metadata">

### Author: ![SamehSaeed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samehsaeed/32/145262_2.png) [@SamehSaeed](https://discuss.elastic.co/u/SamehSaeed)
#### Post date: [February 12, 2024, 11:55am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/5 "2024-02-12T11:55:28Z")

</div>

Received an error, I was trying to get the same value of "Final Status" from 5 minutes ago then make another runtime field (or the same field if possible) that will hold the difference between the 2 and thats how i can indicate that this value was update in the last interval. However, i remembered that this is an aggregation, so "Final Status - 5" would have no meaning, unless i can extract the count of "Final Status -5". Right now i don't see anyway to calculate it unless i make another pipeline in logstash that directly retrieves the count, count -5 minutes and the difference.

Anyway, runtime field I have tried :

```auto
long fiveMinutesAgoTimestamp = doc['call_start_time'].value.toInstant().toEpochMilli() - 5 * 60 * 1000;
def fiveMinutesAgoDocument = doc['call_start_time'].value[fiveMinutesAgoTimestamp];
return fiveMinutesAgoDocument != null ? fiveMinutesAgoDocument['Final Status'] : null;

```

error :

```auto
Cannot cast null to a primitive type [void].

```

Note : this script was generated by AI as i have zero knowledge of painless scripts

---

<div class="post-metadata">

### Author: ![SamehSaeed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/samehsaeed/32/145262_2.png) [@SamehSaeed](https://discuss.elastic.co/u/SamehSaeed)
#### Post date: [February 14, 2024, 8:58am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/6 "2024-02-14T08:58:39Z")

</div>

Found something that might solve this, though I'm still working on it : [353243](https://discuss.elastic.co/t/kibana-formula-reducedtimerange-not-working/353243)

---

<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: [March 13, 2024, 8:59am UTC](https://discuss.elastic.co/t/kibana-dashboard-values-changing-indicators/352734/7 "2024-03-13T08:59:24Z")

</div>

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