topic How to calculate request arrival rate only for weekdays and exclude weekends for PST time? in Splunk Search

How to calculate request arrival rate only for weekdays and exclude weekends for PST time?

rajhemant26 — Fri, 15 Mar 2019 05:57:01 GMT

Hello everyone.

Want to display the output only for the time which crosses 18 months (earliest time)

Re: How to calculate request arrival rate only for weekdays and exclude weekends for PST time?

adonio — Fri, 15 Mar 2019 17:45:57 GMT

many answers in this portal, here are couple:
https://answers.splunk.com/answers/426673/how-to-filter-out-weekdays-or-weekends-in-one-sear.html
https://answers.splunk.com/answers/660420/how-to-exclude-weekends-from-last-30-days-search.html
you can address the time in many different ways, depending on your user setting, timestamp, and other.
if data is generated in the West Coast, you can also try and use _indextime

hope it helps

Re: How to calculate request arrival rate only for weekdays and exclude weekends for PST time?

woodcock — Fri, 15 Mar 2019 18:10:41 GMT

For the PST part, run the search as a user that had <LoginID> -> Preferences -> Time zone to PST.
For the other part, you can add something like this to your search:

... | eval date_wday = strftime(_time, "%a")
| where NOT (date_wday = "Sat" OR date_wday = "Sun")