How to fetch the best business week-day for month of September ?

[rajakabdual]

Please help me with my search:

index=sales sourcetype=csv  source= sales_new.csv

[kmaron]

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

This will give you one single day with the most sales that is a weekday.

[TISKAR]

Hello,

And if you try this,

index=sales sourcetype=csv source= sales_new.csv date_month=september
| timechart span=1d count

Best

[deepashri_123]

Hey rajakabdual,

Can u try the following query:

index=sales sourcetype=csv source= sales_new.csv earliest=-1mon@mon
| timechart span=1d count

Let me know if this helps!!

[somesoni2]

When you do say a business day is "best"? Any specific field that you sum/count?

[skoelpin]

Assuming you want the highest count per day over a month period. Try this

 index=sales sourcetype=csv  source= sales_new.csv
| timechart span=1d count

[rajakabdual]

Hi skoelpin, thanks for answering but my query is i need only September month business weekdays only

[adonio]

please share some more love so we can better assist you
do you have time fields? a little sample data will help

[rajakabdual]

yes adonio, here some of my time fields are date_wday ,date_month