Please help me with my search:
index=sales sourcetype=csv source= sales_new.csv
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.
Hello,
And if you try this,
index=sales sourcetype=csv source= sales_new.csv date_month=september
| timechart span=1d count
Best
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!!
When you do say a business day is "best"? Any specific field that you sum/count?
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
Hi skoelpin, thanks for answering but my query is i need only September month business weekdays only
please share some more love so we can better assist you
do you have time fields? a little sample data will help
yes adonio, here some of my time fields are date_wday ,date_month