hi i need the December month sales by week number , given below i am sharing my index name and other fileds name also.
index= sales sourcetype=csv source= sales_new.csv and fields are date_month ,date_wday,Sales
You can use :
index= sales sourcetype=csv source= sales_new.csv date_month=december | timechart span=1w count | eval day=strftime(_time,"%d") | eval week_number=floor(day/7)+1
You can use :
index= sales sourcetype=csv source= sales_new.csv date_month=december | timechart span=1w count | eval day=strftime(_time,"%d") | eval week_number=floor(day/7)+1
Hi P_gurav, thank you for the grate help its working fine and i am looking for the same.
Hey rajakbdual,
Can u try something like this:
index=sales sourcetype=csv source=sales_new.csv date_month=december | timechart span=1w Sales
Let me know if this helps!!
Hey deepashri,
sorry i am getting the error at |timechart span=1w Sales