How do I structure the data for this waterfall chart?

Q&A
,
1

Hi! I feel like Ive tried everything, but cant seem to be able to replicate this visual in Quicksight.

Im hoping someone can share exactly how this data should be structured (with some fake numbers) for me to load into the chart, since I am unable to wrap my head around the category/breakdown/value fields.

Screenshot 2025-09-11 at 3.22.01 PM
Screenshot 2025-09-11 at 3.22.01 PM1346×846 40.7 KB

3

Hello asdf1,

Welcome to the Quick Sight community.

Please see the char types here to get some idea not sure if it helps though - https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Chart-Types

and

Refer here

Cheers,

Deep

1 Like
4

Hi

Thanks for the link, this is a great resource! I have seen the thread you shared and it seems like my situation is a bit more complicated because the breakdowns are not repeating amongst categories. Is there a workaround for this? I cant seem to get the data in the right format.

5

Hi @asdf1,

Hope this message finds you well! Just checking back in since this thread hasn’t had a response in a while. Were you able to find a workaround for the waterfall chart in the meantime or are you still running into persistent issues? If we do not hear back within the next 3 business days, I’ll go ahead and close out of this topic.

Thank you!

1 Like
6

no. I never found a solution.

7

Hi @asdf1,

This is a very basic data structure, but I believe the one depicted below should correspond to making the waterfall chart that you want. Once imported, you would put Column A as the Category (Prior Period MOQ and Total ARR are used as the baselines), Column B as the Breakdown for those baselines, and Column C as the respective Values. Hope this helps!

image
image480×147 38.1 KB

1 Like
8

Thank you, I will give this a try!

1 Like
9

Hi @asdf1,

Hope everything is well with you! Just checking back in to see if my recommendation helped solve your question or if you are still facing persistent issues.

Thanks!

10

Hi @asdf1,

Since we have not heard back further regarding this topic, I’ll go ahead and close out this post. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you