Sales of each weekday by week number for month of December

[rajakabdual]

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

[p_gurav · Accepted solution]

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

[rajakabdual]

Hi P_gurav, thank you for the grate help its working fine and i am looking for the same.

[deepashri_123]

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!!

[rajakabdual]

Hey deepashri,
sorry i am getting the error at |timechart span=1w Sales