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!

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 ...