# Time series kibana

**URL:** https://discuss.elastic.co/t/time-series-kibana/268805
**Category:** Kibana
**Created:** [March 30, 2021, 2:33pm UTC](https://discuss.elastic.co/t/time-series-kibana/268805 "2021-03-30T14:33:20Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Jose\_Manuel\_Tirado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jose_manuel_tirado/32/84882_2.png) [@Jose\_Manuel\_Tirado](https://discuss.elastic.co/u/Jose_Manuel_Tirado)
#### Post date: [March 30, 2021, 2:33pm UTC](https://discuss.elastic.co/t/time-series-kibana/268805/1 "2021-03-30T14:33:20Z")

</div>

Hi!!:

I want to compare a data set from the last 15 min with the total mean accumulated over time.

How could i do this in kibana?  
I have tried as TSVB and Timelion and cannot get the desired result.

Can anybody help me?

Thanks.

---

<div class="post-metadata">

### Author: ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [March 31, 2021, 6:35am UTC](https://discuss.elastic.co/t/time-series-kibana/268805/2 "2021-03-31T06:35:15Z")

</div>

Hey there, you could use Lens and filters aggregation:

1. Make sure your timepicker is in the right time range to cover all your data.
2. switch to table visualization
3. For rows, create filters aggregation - one for `All records`, one with the timespan you need (here last hour, change 60 to 15 to get 15 minutes)  
 ![Screenshot 2021-03-31 at 08.34.52](https://us1.discourse-cdn.com/elastic/original/3X/5/d/5d9aa7ad7c99691d623c0dff22cc7c3e3cc96c4c.png)

@timestamp \>= "now-60m/m" and @timestamp \<= "now/m"

 ![Screenshot 2021-03-31 at 08.31.55](https://us1.discourse-cdn.com/elastic/original/3X/d/5/d56517c2a80511ca9668f49055844417dc4736e2.png)  
4. For metrics, define the metric you need  
 ![Screenshot 2021-03-31 at 08.32.41](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7d9af1672923422daacfdfab65488154cbfc00f5.png)

Here's the result:

 ![Screenshot 2021-03-31 at 08.33.17](https://us1.discourse-cdn.com/elastic/original/3X/7/2/72e68d330e78eb9cafbfbb0868d6d19428001c0d.png)

It doesn't have to be a datatable, choose whatever chart type you find fit.

 ![Screenshot 2021-03-31 at 08.34.02](https://us1.discourse-cdn.com/elastic/original/3X/9/3/93668d7dd21deeb2c48daa7d7b009dc5906cc83b.png)

---

<div class="post-metadata">

### Author: ![Jose\_Manuel\_Tirado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jose_manuel_tirado/32/84882_2.png) [@Jose\_Manuel\_Tirado](https://discuss.elastic.co/u/Jose_Manuel_Tirado)
#### Post date: [March 31, 2021, 7:23am UTC](https://discuss.elastic.co/t/time-series-kibana/268805/3 "2021-03-31T07:23:56Z")

</div>

Hi Marta and thanks!!

I do not have Lens in my kibana, how could I do the same but without Lens, because I have tried and I do not get the same result.

Thank you very much for your time and I await an answer.

Greetings

---

<div class="post-metadata">

### Author: ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [March 31, 2021, 4:07pm UTC](https://discuss.elastic.co/t/time-series-kibana/268805/4 "2021-03-31T16:07:13Z")

</div>

You can do the same thing in any Visualize editor, for example Vertical Chart or Datatable. Here's the configuration for the similar example:

 ![Screenshot 2021-03-31 at 18.06.58](https://us1.discourse-cdn.com/elastic/original/3X/3/b/3bf9f8ced073452991142e0257b8419f672c808d.png)

---

<div class="post-metadata">

### Author: ![Jose\_Manuel\_Tirado](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jose_manuel_tirado/32/84882_2.png) [@Jose\_Manuel\_Tirado](https://discuss.elastic.co/u/Jose_Manuel_Tirado)
#### Post date: [April 5, 2021, 6:25am UTC](https://discuss.elastic.co/t/time-series-kibana/268805/5 "2021-04-05T06:25:41Z")

</div>

HI!!

I can't leave filter 1 blank, because it throws me an error that I can put in filter 1?

Thanks!!

---

<div class="post-metadata">

### Author: ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)
#### Post date: [April 13, 2021, 8:24am UTC](https://discuss.elastic.co/t/time-series-kibana/268805/6 "2021-04-13T08:24:46Z")

</div>

Hi @Jose_Manuel_Tirado , that's surprising, it allows me to leave it blank, but you can target all records with '\*'

 ![Screenshot 2021-04-13 at 10.24.39](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fd7ee1f38204167005f97cf398bcb91a1007c82b.png)

---

<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: [May 11, 2021, 8:25am UTC](https://discuss.elastic.co/t/time-series-kibana/268805/7 "2021-05-11T08:25:39Z")

</div>

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