I have a worksheet that displays price counts per week. Each bar is a week. Each week the clients would login and view data for the previous weeks.
How can I prevent the chart from displaying the current week without hard-coding anything? I tried using the Date as a filter, but the "Last x weeks" will include the current one.
Is there perhaps a formula I could use (something along the lines of a "week - 1") or something?
By creating a calculated field similar to the following, placing it on the filter shelf and selecting 'Show' will give this effect:
if datepart('week', Date)=datepart('week', today()) then 'Hide' else 'Show' end
Hope this helps!