Automate dashboard to pdf by changing filters

[chbabhi]

Hi Team,

I have a dashboard which has several filters. We need to produce a pdf report to the leadership by having a separate page for each filter value. Since there are a lot of filters, it results in 50+ combinations meaning we will need to generate 50+ pages.

Is there anyway to automate this process of changing filter and exporting the page to a pdf?

Thanks,
Abhiram

[Wakana]

hi @chbabhi

there is Snapshot Export API released a few months ago, which can automate to generate PDF report. if 50+ filters are linked to parameters, you can specify the parameter values when using the API. the following video and blog explains further details.

Programmatic Export to Excel Using the New Snapshot APIs: 2023 Amazon QuickSight Learning Series

[Programmatic Export to Excel Using the New Snapshot APIs: 2023 Amazon QuickSight Learning Series] This is a companion discussion topic for the original entry at https://www.youtube.com/watch?v=pC9mXpy7208 References: AWS CLI Command Reference https://awscli.amazonaws.com/v2/documentation/api/latest/reference/quicksight/index.html DemoCentral Financial Dashboard example: https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Free-form-RSU-Tax-Report Amazon Q…

Automate financial statements using Amazon QuickSight Snapshot Export APIs

Financial statements are a set of documents that contain formal records of financial activities of a business at a specific point in time. For example, a profit and loss (P&L) statement summarizes the revenues, expenses, and resulting net profit or loss of a business. It is a snapshot of the organization’s financial performance, starting from the organization’s total revenue, followed by the deductions for the costs of goods sold and operating expenses. By analyzing these profits, business leade…

hope this helps

kind regards,
Wakana

[chbabhi]

Thanks for taking the time to provide the information. I will go through the links to understand more in detail.

Thanks,
Abhiram