I'm running into an issue where I need to use two date variables in an app studio app so users can select a start and end date, however, the data used in the dashboard is only updated monthly, halfway through the month. Right now I have it set up to look at the beginning of the year as the start date and "yesterday" as the end date. It would be great if I can make the end date based on the last day of data available in the dataset. I can't use a regular filter card because it doesn't let me select a default date so this is why I'm using variables.
