I’m trying to replicate functionality available in a competitive tool in QuickSight. The challenge is as follows:
Assume a single data source with 2 columns, a Date Column and a Quantity Column.
The ask is to create an analysis that compares the sum of Quantity for one range of dates to the sum of Quantity for a different range of dates in a KPI visualization.
For example, a comparison of total quantity for January 1, 2021 thru January 15, 2021 to the total quantity for Feb 3, 2021 thru Feb 17, 2021…with the ability to set the date ranges through date controls.
Have tried creating an analysis with two data sets but I can’t seem to populate the visualization with data from two separate data sets.
Thoughts on an approach?