Splunk Search

x-axis to display 3hours interval

HelpMePlease
Explorer

I had a x-axis displayed over date_hour. 00,01,02... Is is possible to change it to display on a 3hour basis (00,03,06).

My search query

sourcetype="CurrentWeatherSGMap" Message="Yishun" earliest=@d latest=-0m@m | eval 24-hour=strftime(_time,"%H") | eval Description=case(current_summary="Cloudy", "Fair",current_summary="Rain", "Poor",current_summary="Showers","Poor",current_summary="Passing Showers","Poor",current_summary="Thundery Showers","Poor",  current_summary="Partly Cloudy", "Excellent") | chart dc(Description) over 24-hour by Description | eval Fair=if(Excellent==1,"1",Fair) |  eval Poor=if(Description==Poor, "1", "1")
Tags (2)
1 Solution

HelpMePlease
Explorer

Solved using bucket _time span=3h | eval _time=strftime(_time,"%H")

View solution in original post

0 Karma

HelpMePlease
Explorer

Solved using bucket _time span=3h | eval _time=strftime(_time,"%H")

0 Karma

clymbouris
Path Finder

You can make a timechart. Something like..

search... | timechart span=3h count

0 Karma

HelpMePlease
Explorer

thanks !!!

0 Karma

linu1988
Champion

Use bucket _time span=3h

HelpMePlease
Explorer

If I have a chart, how can I do that ?

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Index This | How many sevens are there between 1 and 100?

August 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

What Is Splunk? Here’s What You Can Do with Splunk

Hey Splunk Community, we know you know Splunk. You likely leverage its unparalleled ability to ingest, index, ...