Hi Folks!This might be a really basic question but I can't work it out!I've been using the Pie Chart to show the sales by Price Type category and I love that it shows me the percentage of sales of each price type.Is there a way for the Y-axis of Bar Chart to be the percentage - so each bar is the percentage of sales per price type - rather than the actual numberI'm more interested in the ratio than the actual numbers but prefer the look of the Bar Chart in my dashboard
Cheers, Nicola
Yes, you can use a 100% stacked column chart.
Hi Nicola,
+1 Ilana's comment, especially if this is in an effort to resolve having multiple pie charts for different productions and consolidate that into a single widget.
If you'd like to see the Price Type Categories in separate bars, you can leave it as a Simple bar chart, and hover your mouse over the Value field, click the Options menu (three lines at the right), select Quick Functions, and then Contribution.
Then change the number format on the value to a percentage.
Thanks so much Chris, This is exactly what I was looking for!Now I've got separate bars with the percentage for total for each mode of sale! Thank you!
Hi Ilana,Thanks for responding! For some reason when I'm trying to look at total tickets per price type or mode of sale, I cant select a stacked column chart at all.I was able to do it using the contribution function as Chris described below for separate bars :)