I’m working on building a Waterfall Chart to show week-over-week changes in key operational metrics (like actual_ids_percentage, forecasted_tbr, actual_total_stows, etc.). Here’s what I want to achieve:
Allow the user to select a current week (e.g., Week 23).
Allow the user to select one or more offset weeks (e.g., -4, -11) relative to the current week.
Visualize a Waterfall Chart where:
Each bar shows the delta between the selected current week and an offset week for each metric.
The user can select different offsets to dynamically see how the KPIs have changed over time.
My data contains:
year
week
Metrics in separate columns (e.g., actual_ids_percentage, forecasted_tbr, etc.)
Hello @isingla, this functionality should definitely be possible in QuickSight! Is there any data in that CSV that is sensitive? If not, you can insert it as a dataset in the QuickSight Arena and build an introductory version of the chart that we can work from together.
That would allow me to test some options directly in QuickSight to find a solution that works for you. With some custom parameters, and calculated fields, we should be able to manage your expectations.
