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!
| table shift count