Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've been requested to omit the current week from a rolling average chart.
calculated dimension expression currently used: =date(WeekStart(dev_finish_date),'MMM-D')
I was able to display only the last 13 weeks via the chart property "Max Visible Number", but is there any way to NOT display the current week?
-----ALSO-----
They want the weeks to start on Sundays as opposed to Mondays. I've found things regarding this on the site, but don't know how to relate the unassociated chunks of code they suggest to mesh with all the date fields I've linked to in the database.
I found out I didn't need some extraneous Master Calendar script!!! Here's what I did.
Voila, it doesn't show any incomplete weeks. Just remember the main things that assisted were the search box and the bookmark. I'm sorry if it doesn't explain too much, but it's a whole lot easier than a Master Calendar script AND there's no variables to create and store.