Copying visual formatting from one Analysis to the other

Question & Answer
, , , , ,
1

Hello all,

I have a use-case where I have a standardized Analysis with visuals, but need to plug different datasets to the standardized analysis to create different dashboards. How can I connect different datasets to the same analysis, or will I have to manually build each one with the dataset?

To provide a more intuitive understanding, I am working with government contracting data. The fields are standardized across countries, (i.e. total purchases, contracts, etc), but I have to create a dashboard for each country, as each has its own source.

Any ideas that would spare me having to rebuild the same analysis 10 - or maybe 100 - times?

2

Hi @hdezeduardo ,

Welcome back to the QuickSight Community!

I can think of 2 ways to do this :

  1. If you can create a composite dataset with all data sources collated (union All in SQL terms) and setup a RLS based on country/ region, you can do this using single analysis.

  2. If single dataset is not an option, then you may need to save a copy of the analysis and replace the datasets in the existing analysis. This way you may not need to develop from scratch, but will need to configure dataset replacements ensuring the schema matches and publish the analysis to new dashboards.

Thanks,
Prantika

3

Hi @hdezeduardo, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!