I want to filter last month data, but no last 30 days from today as I have found but last month of available data.
today is 24/4
but last data I have available is 31/3
so I would like to filter all march instead of 25/3 to 24/4 as I get now, because I have no data from april...
any suggestion? is it possible to do it without doing a special query just to filter dates and joining queries?
With another project I used a saved question as a initial table with data filtered by last month available but to add a filter now... If I have to change the table of the question, I have to redo all the questions again... and thats a lot of work. Because that's another important question... any TIP to change the origin of a question and not loosing all the work done??