How to exclude current month from question?

[nathan.l]

I’m producing a dashboard to show YTD financial figures, but I want to exclude the current month so only complete months’ data get aggregated. I can do this using SQL, but I’m trying to do it using a ‘Question’ (cos of the data model it analyses). I don’t want to have to go in every month and edit the date ranges, I’d like it to just automatically exclude the current month. I can include the current month, I just can’t find a way to exclude it. If you could make it possible to select a timeframe and say ‘NOT’ this timeframe, that would solve the problem for me.

[dwhitemv]

The default for dashboard filters for previous months doesn’t include the current month unless you flip the checkbox. You should be able to set the filter to “previous 1 month” and get what you want.