Creating a Stacked Bar Chart for Visitor Conversion by Week

[nahuel_z]

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.

[ChiragGarg2512]

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

[nahuel_z]

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]

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.