How to get time in x chart axis?

[jip31]

hi

I use a timechart which is linked to a "today" token time 

On the x axis, I need only to display events between 7h and 19h

I tried this but the x axis go to 0.00h from the current time

How to do for the x axis begin only a 7h00?

thanks

index=toto
| eval local_time=strftime('_time', "%H%M") 
| search local_time >="0700" AND local_time <="1900" 
| timechart span=15min dc(s) as user by type

[SanjayReddy]

Hi @jip31 

assigne localtime as _time 

index=toto
| eval local_time=strftime('_time', "%H%M")
| eval _time=local_time
| search _time>="0700" AND _time<="1900"
| timechart span=15min dc(s) as user by type

[jip31]

thanks but i have an issue on the x axis which is converted in hour minutes

how to avoid this?

[SanjayReddy · Accepted solution]

Hi @jip31 

time is coming as hour minuites because you are converting only %H %M in strftime 
if you want to add as date please add vatiables you needed 

FYI 

| eval local_time=strftime('_time', "%H%M")

[jip31]

I convert in hour minutes in order to choose only events in this slot time

so is it possible to do this while having good date format in x axis?