Forum Discussion

Matt_Hutch's avatar
Matt_Hutch
Frequent Visitor
4 years ago

waterfall Chart

I've created a simple waterfall chart for Market Share across 5 Regions. This works well enough although the total figure for the waterfall adds the 5 regions rather than actual Market share of the 5 combined Regions

Need Help

4 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    Hi Matt_Hutch ,

     

    Can you add some screenshots here on what chart have you got and what is the issue?

     

    Thanks,

    Pragati

  • Matt_Hutch's avatar
    Matt_Hutch
    Frequent Visitor
    4 years ago

    drives the Waterfall chart to:

     

    As you can see the total is the sum of the regions rather than the actual share of the universe of 2.58%

    • Pragati11's avatar
      Pragati11
      Super User
      4 years ago

      Hi Matt_Hutch ,

       

      What do these %-age values represent? Are they calculated somehow using the actual values? Are they something like percentage of grand total?

       

      Thanks,

      Pragati

      • Matt_Hutch's avatar
        Matt_Hutch
        Frequent Visitor
        4 years ago

        They are market shares by Region. So my sales/ total sales. 

         

        Hence the Region sales are correct but the waterfall adds the 4 Regions share rather than doing our total sales combined/ total sales combined