Modify x-axis timestamp interval


#1

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:


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

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.


(Lukas Olson) #2

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.


#3

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


(system) #4

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