@TomG I can't believe a solution so simple escaped me. Thanks for suggesting, I think this is the best way forward.
In all my times using widget filters, i'd never even noticed the advanced filter option at the top of the dropdown! Thanks alot.
I assumed this was the only way to do it currently, just wondered if anyone had a solution that would allow this to tick over every month automatically. We'll potentially have a few reports that would require manual intervention every month if this is the only solution.
I can (and have) set a time constraint on the metric to show the last 3 months which is fine. What we want to be able to do is to show a trend table of these results. The same way you can use a rolling metric in a simple table or graph to show a building set of results. Showing these 3 month weighted results in isolation is one thing, but we want to be able to trend these month to month. I've edited the original post to include this detail, thanks.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.