Forum Discussion

Rudyi's avatar
Rudyi
Helper I
6 years ago

Waterfall chart to show increase and decrease per day

Dear all,

Can you please advise if there is a way to build a waterfall chart to show both "Increase" and "decrease" between days?

When I'm trying to build it - I can usually show only "delta" per day, but not so much "+" as "-"

Sample data below

Category Date Amount Increase Decrease

AAA 01.05.20 10000 1000 500

AAA 02.05.20 10500 1500 1000

AAA 03.05.20 11000 1000 1000

Thanks for the help!

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Rudyi ,

    What's your expected result? Could you please provide the screen shot to describe it?


    When I'm trying to build it - I can usually show only "delta" per day, but not so much "+" as "-"


    Best Regards

    Rena

    • AleksanderPunt's avatar
      AleksanderPunt
      Helper I

      Hm, after reading your request once more, I'm not quite sure I understand what you mean by showing both increase and decrease.

      I mean, either an article has increased or it has decreased as a total..?

       

      I use waterfall to display monthly development (increase/decrease) as a total for multiple articles.

      If I click on a monthly bar, it drills down to display all articles and their individual increase/decrease for that month.

      Furthermore, I can click on an article to show increase/decrease per customer for that article, that month.

      The monthly sequence can just as easy be weekly or daily.

       

      Perhaps it would be helpful if you drew an example of how you want it to look, and post the picture?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Rudyi ï¼Œ

        I'm sorry I didn't find a suitable waterfall chart that can display data like the chart in your screenshot. Please check if Line and Clustered Column Chart can meets your needs.

        Best Regards

        Rena