Hello,
I am planning to add two datasets to a single analysis, and publish this as a dashboard. In my analysis, I want to have different visuals for different granularities. For example, my first dataset will be monthly, and my second dataset will be yearly. My visuals for each dataset will be completely separate from each other.
Would there be any issues with presenting this in my analysis?
Hi @jonathan_tso,
There shouldn’t be any issues. You just need to be consistent when naming your fields in the 2 datasets if you want to apply the same filters to both visuals. For example, if you want to filter by “Company Name”, you can’t have “Company Name” in one dataset and “Company_Name” in the other.
1 Like
Here are few approaches you could use when dealing with multiple datasets -
- Any unrelated datasets which cannot be joined on a common key/field, can be added directly to the Quicksight Analyses.
- Any related datasets that have a common key, can be combined/joined into a single dataset in the ‘dataset editor’ within Quick Sight and then be used in your analyses.
Advantages:
- It avoids the confusion of same/consistent names across the datasets, as you are only bring one of the common fields into the final dataset instead of both. Ex: You will only have one ‘Company Name’ field in your final dataset created by joining dataset A and B (where both datasets have ‘Company Name’ field)
- Provides better performance than joining it later in your analyses.
- In few regions, you can add a maximum of 10 datasets per analyses in Quick Sight Standard Edition and 50 datasets per analyses in Quick Sight Enterprise Edition.
- If you need to work with more than the maximum number of datasets, consider creating multiple analyses and combine these analyses in a single dashboard, or use ETL/custom SQL to combine data in Amazon Athena/Redshift and use that as data source in your dataset/Analyses.
Hope this helps.
Thanks!