Calculate and filter dashboard by last business day instead then previous day.

Yes, you can set up an automated report based on the last business day in Amazon QuickSight. While there isn't a direct "last business day" filter option, you can achieve this using a combination of relative date filtering and the isWorkDay function.

Here's how you can approach this:

1. First, create a calculated field using the isWorkDay function to determine if a date is a business day. For example: is_business_day = isWorkDay(your_date_column)

2. Then, create a filter using the relative date option. Set it to filter for the "Previous" day.

3. Combine this with the calculated field you created. This way, you'll filter for the most recent day that was also a business day.

To set this up in your dashboard:

1. Go to the Filters pane in your dashboard.
2. Add a new filter for your date column.
3. Choose "Date & time range" as the filter type.
4. Select "Set a rolling date" and choose "Relative date".
5. Set the filter condition to "End of", Range to "Previous", and Period to "Day".
6. Add another filter using your calculated "is_business_day" field and set it to include only the days where this field equals 1 (indicating a business day).

This combination will effectively filter your data to show only the last business day. You can then use this filter setup when creating your automated report schedule.

Remember that this approach assumes a standard Monday to Friday work week. If your business days differ, you may need to adjust the isWorkDay function accordingly.
Sources
Adding date filters - Amazon QuickSight
RelativeDatesFilter - Amazon QuickSight
isWorkDay - Amazon QuickSight
Filtering data during your session in Amazon QuickSight - Amazon QuickSight