Pass paramater value to paginated report or dashboard for filter

Is there a way to pass a paramater value to a paginated report/dashboard to filter results. I need to create/schedule/email a separate paginated pdf report for several product lines. All reports have the same layout. I would like one paginated report layout with the ability to pass the product line as a paramater to the sheet/paginated report/dashboard. One dashboard per product line would work but I only seem to be able to use the default static value of the paramater on the paginated reports.

I know this can be done with the cli or code lib by using the start-dashboard-snapshot-job and passing a json object with variables including paramater values. I need something similar but scheduled and sent via quicksight email and integrated into the familiar dashboards the CEO is getting used to rather than sticking files into an S3 bucket that is not as accessable or intuative. If the start-dashboard-snapshot-job could update the dashboard paginated report view with the updated results that would also work but it I don’t see the option.

Is there a better way to do this? Am I missing something?

Hello @scoeat !

From my experience what you described about creating one dashboard per product will probably be the best way to do. I believe at this time you can not pass a parameter value in a scheduled email report.

I will mark this as a feature request for the Quicksight team! I believe this persons request is along the same line as yours.

1 Like