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
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...