on 08-02-2016 8:56 PM
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.
Can you check this thread to see if the solution will help you - go to the Compose room and try it: How to change Lines and Columns in Combined Col... | SCN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Adam,
In the visualize room, pull in the measures and dimensions as below.
In the compose when you drag this chart into the canvas, you can change the series type for the measure you select.
This should give you the desired result. Please let me know if there are any questions or comments.
Thank you,
Varun Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.