Skip to Content
0
Aug 02, 2016 at 07:56 PM

Combined Column Line Chart w/ 2 Y-Axes - Need to switch graphics

83 Views

Hi all,

I'm building a visualization in Lumira 1.29. I have three metrics: Sales Actual $ (SUM), Gross Profit $ (SUM), and Hours Worked (SUM). I want the Sales Act and Gross Profit numbers to be on a column chart, right next to each other so I can compare the two. Then I want to add Hours Worked to the chart and have that appear as a line going up and down along from left to right on it's own Y-Axis.

I have drilled these KPIs across by Year/Month.

I chose Combined Column Line Chart w/ 2 Y-Axes. When I add the Sales Actual and Gross Profit measures into the "Left Y Axis" and Hours Worked into the "Right Y Axis" and Month into the X Axis, the Sales Actual shows up as a column and the Hours worked do to. The Gross Profit shows up as the line.

What I want is the Gross Profit to show up as another column and the Hours Worked to show up as a line.

I can't find anywhere in Lumira on how to change how these measures appear in the chart. Do I have any options?

Screenshot attached.

Attachments