Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating a Stacked Bar Chart for Visitor Conversion by Week

 

Hi.

I want to create a stacked bar chart. I want the X-axis to represent the weeks of the year, and the overall Y-axis to represent the number of visitors to my website as whole numbers. Within each bar, I want to display the number of tickets as a percentage. This percentage should be based on the total number of visitors. In summary, I want to graph visitors as whole numbers and conversion as a percentage.

Like this.

Tips and Tricks
Tutorial Requests

3 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    Anonymous use secondary y-axis and change the type of column from number to percentage.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I have already tried that, but it was not possible. I can only display the secondary axis if I plot it as a line. However, I want it to be a bar within the bar. Thank you.

      • ChiragGarg2512's avatar
        ChiragGarg2512
        Solution Sage
        2 years ago

        Two different fields can not be a part of the same column. A single bar in column visual cannot be used to represent to different thing. When legend is introduced to the column visual, it breaks the total for that column into multiple pieces according to the percentage value of that piece.