display date for whole week on x-axis in chart

[c83user]

I need to display summary of productlines for each product ,for the whole week.if today is thursday the xaxis should display count for producs(camping equipment,cookin gear)etc for mon ,tuesd and wednesday.if its start of the week .i need to display the product count for monday.

How do i put in a date calculation so that i get the dates on the xaxis for each product separately.

 

[c83user]

I used this filter for date.


[Ls_DATe]>=(CASE (_day_of_week(current_date,1))
WHEN 1 THEN _add_days(current_date,1)
WHEN 2 THEN _add_days(current_date,-2)
WHEN 3 THEN _add_days(current_date,-3)
WHEN 4 THEN _add_days(current_date,-4)
WHEN 5 THEN _add_days(current_date,-5)
WHEN 6 THEN _add_days(current_date,-6)
ELSE _add_days(current_date,-7)
END)



But the chart does'nt show any data when i put in the filter.When i use just one date(i.e current date) i get the correct data for today.But i'm looking for current weeks data instead of just one day.