Question: I want a Column Chart with 3 metrics- 2 of the metrics are stacked while one remains a single Column. I would even consider doing the 2 metrics stacked and the 3rd as a line, but if I choose 'Stacked' as my Column Chart Type, the ability to make the 3rd metric a line goes away.
Solution: You can accomplish this task by taking the following steps:
1. Add Metric A and Metric B to the Values of your column / bar chart per usual. Confirm there is a category included to act as our X axis (Y axis in the case of a bar chart).
2. Toggle over to the "Design" pane of the widget on the top right hand side of the editor, next to the Filters pane. Select Column Type of "Stacked"
3. Add Metric C to the Values of the column / bar chart. Click on the hamburger icon next to its name > show on right axis
4. Click the hamburger icon next to its name again > Series type > Line
5. Apply changes
