I have created a data blend using two data sources: GA4 an a file in Google Sheet. In my dashboard, I would like to display the data on a monthly basis. By default, the dashboard is showing the data for "Last Month" (i.e. in the month of February 2025, the data is shown for January 2025). However, I have included a date filter so that a user can select another month.
Ideally, the blend would also display the data by default, for "Last month" and subsequently, for the user selected month. However, when setting the "Auto" date for the GA4 dataset, the data seems to default to "Last 28 days" instead of the user-selected month. The "Last 28 days" would not make any sense in our case because the Google Sheet will not have data beyond "Last month".
Is there any suggestion what to do in order to show the blended data for the user-selected month?
LinkedIn
Twitter
