How to deal with the 1st of month for "Current month" filter
Context : Each day, we feed DOMO with the data of the day before (for exemple today, the 1st of August, I have data until 31st of July). In some reports, I put only cards with "current month" filter to see the evolution through the month and I allow users to see the date filter in order to interact with the data.
Problem : Today, all the cards of my report are empty because I don't have data for August ! Yet, it would be very interesting to have the vision of the complete month...
How can I take the previous month filter only for the 1st of month ?
I've tried to think about solution but without result... I hope you will have an idea !