How can I create a query that has a fixed date for starting point and end point is end of "last month"?
Any update on this?
I've found a couple good solutions. First is that Supermetrics understands strtodate functions from PHP, so you can use certain language in the date selector, like "last day of last month" and it understands it. The second way I've found is that you can reference a cell in your spreadsheet, like =A2 for the date. If you're comfortable with advanced functions in spreadsheets, you can use a function or even create a custom function, to get to the start and end dates you want - and then just reference those dates in a cell from Supermetrics.