Workspace - Dates
Hi,
I am showing a free form table with the rolling date range of End of Current day minus 8 days and End of Current day minus 1 day. My goal is to show the data for the prior 7 days whenever the report is opened. However, it keeps on showing 8 days with the 8th day showing all zeros. For example, today it is showing 6/24 - 7/1 with 6/24 zeros for all metrics (visits, orders, revenue). I'd expect it to only show 6/24 - 6/1. I tried doing the show selected cells only but that did not refresh on subsequent days, it stayed with the dates I selected as visible only.
Thanks.