What is the best practice way currently in QuickSight to prep your data in a way to show comparison numbers?
For Example, QuickSight Visualizations only allow for 1 dataset to be used to bring in fields to display content in, so if your Sales and Sales Forecast numbers are in 2 different fact tables, how can we get this into 1 dataset?
Ideas:
- Prep your data before bringing into QuickSight, by creating a merge summary table that displays both sales and sales forecast numbers by yearmonth.
?