Splunk Search

How to split time into 3 shifts with labels on x-axis?

dzyfer
Path Finder

Hi, I have a timechart that is currently split into 8-hour shift bins, however as it is a timechart, the x-axis only shows the timestamps, while I would like the bins to be labeled by their shifts.

Sample data:

Count | Time | Shift

500 | 0700 (Yesterday) | Shift A

750 | 1500 (Yesterday) | Shift B

500 | 2300 (Yesterday) | Shift C

700 | 0700 (Today) | Shift A

600 | 1500 (Today) | Shift B

 

One tricky part is that "Shift C" overlaps between 2 dates as well.
Any ideas on how to define the time range for the shifts, then split and label the bins by their shifts would be greatly appreciated. Thanks!

Labels (7)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| table shift count
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...