@dtaylor The issue might be because of your bin command which creates time buckets but doesn't give them meaningful shift names. Try to add shift logic after your existing binning: | inputlookup shift_tickets.csv
| eval closed_date = strptime(closed,"%a, %d %b %Y %T %Z"), _time = strptime(occurred,"%a, %d %b %Y %T %Z")
| addinfo
| where _time>=info_min_time AND (_time<=info_max_time OR info_max_time="+Infinity")
| eval hour_min = strftime(closed_date, "%H:%M")
| eval shift = case(
hour_min >= "06:30" AND hour_min < "14:30", "Day Shift",
hour_min >= "14:30" AND hour_min < "22:30", "Evening Shift",
true(), "Night Shift")
| stats count by shift
For weekly trends:
| eval week = strftime(closed_date, "%Y-Week-%U")
| stats count by week, shift This keeps your time filtering logic but adds the shift names you need. Much easier than trying to decode those binned timestamps! Hope this helps. If this Helps Please Upvote.
... View more