# Modify x-axis timestamp interval

**URL:** https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878
**Category:** Kibana
**Created:** [May 15, 2018, 8:07am UTC](https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878 "2018-05-15T08:07:07Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![madou23](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@madou23](https://discuss.elastic.co/u/madou23)
#### Post date: [May 15, 2018, 8:07am UTC](https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878/1 "2018-05-15T08:07:07Z")

</div>

Hi all,

I'm creating a visualization in kibana that count the total number of docs in a specific range of time which in my case between 21h and 23h. I'm using a custom timestamp interval which is 3m and I want to only show docs between 21h and 23h on the x-axis for each day of the week and elimantes space between this interval for each day.  
This is my visualization:

 ![Capture%20du%202018-05-15%2009-57-22](https://us1.discourse-cdn.com/elastic/original/3X/2/c/2cdcb61a994465a11e213996e32e07b07201cf13.png)  
And I want to concatenate data between 21h and 23h for each day and eliminate space (circled interval) between them because there is no data.  
I tried to split series for each day but it only get ride of the line between each interval  
 ![Capture%20du%202018-05-15%2009-55-01](https://us1.discourse-cdn.com/elastic/original/3X/c/1/c11e36d4f676f4e2362eb1f2630cd2970b920fd6.png)  
Is there a way to concatenate these interval to get a continuous line that repeat only the 21h to 23h interval for each day or to draw separately each day of the week from 21h to 23h on the same visualization ?

Thank you.

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [May 15, 2018, 4:52pm UTC](https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878/2 "2018-05-15T16:52:32Z")

</div>

Have you tried using the date range aggregation instead?

I would imagine creating 7 ranges with a format like

From: `now/d+21h` To: `now/d+23h` (Today from 21:00 to 23:00)  
From: `now-1d/d+21h` To: `now-1d/d+23h` (Yesterday from 21:00 to 23:00)  
From: `now-2d/d+21h` To: `now-2d/d+23h` (Two days ago from 21:00 to 23:00)  
etc. etc.

---

<div class="post-metadata">

### Author: ![madou23](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@madou23](https://discuss.elastic.co/u/madou23)
#### Post date: [May 16, 2018, 9:47am UTC](https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878/3 "2018-05-16T09:47:11Z")

</div>

I tried it but it creates a visualization that looks almost the same as the second screenshot that I posted.

---

<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: [June 13, 2018, 9:47am UTC](https://discuss.elastic.co/t/modify-x-axis-timestamp-interval/131878/4 "2018-06-13T09:47:25Z")

</div>

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