https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346283#M170338 <P>Hello,</P> <P>And if you try this,</P> <PRE><CODE>index=sales sourcetype=csv source= sales_new.csv date_month=september | timechart span=1d count </CODE></PRE> <P>Best</P> Tue, 17 Apr 2018 08:49:03 GMT TISKAR 2018-04-17T08:49:03Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346276#M170331 <P>Please help me with my search:</P> <PRE><CODE>index=sales sourcetype=csv source= sales_new.csv </CODE></PRE> Mon, 16 Apr 2018 19:41:25 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346276#M170331 rajakabdual 2018-04-16T19:41:25Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346277#M170332 <P>please share some more love so we can better assist you<BR /> do you have time fields? a little sample data will help</P> Mon, 16 Apr 2018 20:36:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346277#M170332 adonio 2018-04-16T20:36:20Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346278#M170333 <P>Assuming you want the highest count per day over a month period. Try this</P> <PRE><CODE> index=sales sourcetype=csv source= sales_new.csv | timechart span=1d count </CODE></PRE> Mon, 16 Apr 2018 20:43:10 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346278#M170333 skoelpin 2018-04-16T20:43:10Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346279#M170334 <P>When you do say a business day is "best"? Any specific field that you sum/count? </P> Mon, 16 Apr 2018 20:46:53 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346279#M170334 somesoni2 2018-04-16T20:46:53Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346280#M170335 <P>yes adonio, here some of my time fields are date_wday ,date_month </P> Tue, 29 Sep 2020 19:07:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346280#M170335 rajakabdual 2020-09-29T19:07:09Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346281#M170336 <P>Hi skoelpin, thanks for answering but my query is i need only September month business weekdays only</P> Tue, 17 Apr 2018 06:28:21 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346281#M170336 rajakabdual 2018-04-17T06:28:21Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346282#M170337 <P>Hey rajakabdual,</P> <P>Can u try the following query:</P> <P>index=sales sourcetype=csv source= sales_new.csv earliest=-1mon@mon<BR /> | timechart span=1d count</P> <P>Let me know if this helps!!</P> Tue, 17 Apr 2018 07:25:59 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346282#M170337 deepashri_123 2018-04-17T07:25:59Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346283#M170338 <P>Hello,</P> <P>And if you try this,</P> <PRE><CODE>index=sales sourcetype=csv source= sales_new.csv date_month=september | timechart span=1d count </CODE></PRE> <P>Best</P> Tue, 17 Apr 2018 08:49:03 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346283#M170338 TISKAR 2018-04-17T08:49:03Z https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346284#M170339 <PRE><CODE>index=sales sourcetype=csv source= sales_new.csv date_month=september date_wday IN ("monday", "tuesday", "wednesday", "thursday", "friday") | stats sum(sales) as dailysales by date_mday | sort - dailysales limit=1 </CODE></PRE> <P>This will give you one single day with the most sales that is a weekday. </P> Tue, 17 Apr 2018 12:51:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-fetch-the-best-business-week-day-for-month-of-September/m-p/346284#M170339 kmaron 2018-04-17T12:51:54Z