If you are fine with the "22W01" style of weekly date values, all you need to do is assign a weekly format to your date column.
If it is a requirement to have standard date values to represent each week, AND you have VA 8.3 or later, then here is one way to do it:
You need a calculated item and an advanced filter to get this.
First we will create a calculated expression so that every row will contain the value for the entire week:
The Period() operator aggregates the values for the current time period. We need to select _ByWeek_ for the final drop-down here. If your VA is older than the 8.3 release, weekly intervals are not supported and this won't work.
So now that we have a column that has each week's total, we'll want to hide all the date values other than the day of the week we want to show. We'll use an advanced filter to do this:
You make a filter like this by opening the Filters pane and selecting New Filter... Advanced Filter.
This filter uses the DayofWeek() operator and I am selecting "2" which is Monday. So each date displayed in your chart will be a Monday.
So if you create your bar chart using the calculated item above, and you apply the filter, then you can get a result like the bar chart at the top of this post.
Let us know if that helps,
Sam
... View more