# Data display for Hour which has maximum value for a variable

**URL:** https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906
**Category:** Kibana
**Created:** [February 9, 2024, 5:27am UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906 "2024-02-09T05:27:28Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Arshukla](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@Arshukla](https://discuss.elastic.co/u/Arshukla)
#### Post date: [February 9, 2024, 5:27am UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906/1 "2024-02-09T05:27:28Z")

</div>

Hello Team,

I will explain my query with below example.  
I have below data

timestamp,  
Date,  
hour,  
Column A,  
Column B,  
Column C,  
Column D,  
Column E

For last day (from 00:00 to 23:59 Hour), I need only that hour data which has maximum value of Column C

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

In the above table, For 8th Feb 2024, 14 Hour is the Hour which has maximum value of "Column C" out of 24 hours of 8th Feb. All other variables (Column A, B, C, D E, ) are displayed for Hour 14.

For 7th Feb 2024, Hour 15, was the hour which was having maximum value of Column C, so all other variables are displayed for Hour 15

Is there any way to populate this type of data in Kibana using Table or Graphical representation. Please suggest

---

<div class="post-metadata">

### 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: [February 15, 2024, 3:46pm UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906/2 "2024-02-15T15:46:31Z")

</div>

I think you might accomplish this with a [Transform](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html).

I think you could create a transform with a `pivot` on the `top_metrics` aggregation and split that by a `date_histogram`.

The [Transform examples](https://www.elastic.co/guide/en/elasticsearch/reference/current/transform-examples.html) may help with this.

Then the transformed index could be visualized in Lens.

---

<div class="post-metadata">

### Author: ![Arshukla](https://avatars.discourse-cdn.com/v4/letter/a/c68b51/32.png) [@Arshukla](https://discuss.elastic.co/u/Arshukla)
#### Post date: [February 22, 2024, 6:39am UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906/3 "2024-02-22T06:39:41Z")

</div>

Can you explain using any example please

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [February 24, 2024, 1:20am UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906/4 "2024-02-24T01:20:58Z")

</div>

Hello, the Transform examples are linked in the post above: [Transform examples | Elasticsearch Guide [8.12] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/transform-examples.html)

---

<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 23, 2024, 1:21am UTC](https://discuss.elastic.co/t/data-display-for-hour-which-has-maximum-value-for-a-variable/352906/5 "2024-03-23T01:21:25Z")

</div>

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