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.
Hello @isingla, I wanted to check in and see if you would be able to follow up with the Arena analysis so we can work on develop a solution to this issue together. That would be the best way for us to figure out a way to accomplish this task. If we do not hear back from you in 3 days with more information, I will close out this topic. Thank you!
Hello @isingla, since we have not heard back with any follow-up information, I will close out this topic. If you need further assistance, please post a new question in the community and include a link to this topic to provide relevant information. Thank you!
