Custom Month Filter for building cards
I am currently building simple gauge cards that show sales for today, week, and month vs our goal for each of those. (see screenshot)
Is there a way for the 'This Month' card to have a custom date range each month and have that automated so I don't have to change all the cards each month to a new date range? I work in retail so each month is different and it depends on start of week not starting with the first of the month. For example this month (September) for us is from August 29th-Oct 2nd.
Hopefully there is a way without too much calculations. Thanks in advance.