CODEWITHSUNDEEP
tableau-apicolumn-chart
James
James

Reputation: 673

Tableau: stacked column with line

I'm trying to graph workload (by day) stacking hours from tasks. I'd like to add a line indicating daily capacity of the relevant resource. I have a table for tasks and table for daily resource capacity.

When adding capacity as an independent data source, I get an error indicating I need a relationship to the primary data source.

If I join the data (on date and resource), I can get a capacity line to show, but only by adding it to the secondary axis, which leads to mismatching of scales (unless I lock in the same maximum scale for both primary and secondary axes). This works, but it's less than ideal : a) it requires foreknowledge of maximum load, b) lower usage resources barely move off the horizontal axis, c) it seems to force the capacity line to use the same color palette as the column chart, plotting each time period with a different color.

Does anyone have any better suggestions?

Upvotes: 0

Views: 140

Answers (1)

lampbob
lampbob

Reputation: 781

So both axes are hours? You can synchronise the two axes to make it dynamic. Just right click on the axis on the right and there should be a check box titled "synchronize dual axes". Check that and it will sync both of them and will responded to changes dynamically.

You can also then hide the axis marks for hours on the right to make it look better. Again right click the axis and deselect the "Show Header" option.

Upvotes: 1

Related Questions