2 Replies Latest reply on Nov 3, 2013 8:05 PM by Jonathan Drummey

# Graphs with Multiple Measure

Folks, I am having difficulty in the following issue:

How to show 3 measures in a combination chart where 2 measures will be in the form of bar graph side by side (not stacked) and the last one

in the form of line graph? The X-axis has the date dimension.

I did see the solution in the link http://community.tableau.com/thread/127020. However, the structure

of data in my data set is a little different. All the 3 measures are in one row. The solution given in the link http://community.tableau.com/thread/127020

has the underlying data where each measure is in a different row based on a category code.

Underlying Data in My Workbook:

Date             Measure1   Measure2   Measure3

-----            --------   --------   --------

01/01/2013        Value1     Value2    Value3

Date             Category   Measure

-----            --------   --------

28/12/2012        Measure1   Value1

01/01/2013        Measure2   Value2

01/04/2013        Measure3   Value3.

• ###### 1. Re: Graphs with Multiple Measure

Hi Ana,

Don't you mind to post a package workbook with sample data? That will facilitate us to find a solution for you.

Best,

Ramon

• ###### 2. Re: Graphs with Multiple Measure

You'll need to reshape your data to do this in order to get the dimension to use to build the calculated fields (which is step 2 in the answer marked Correct on the post you linked). You can use the Tableau data reshaper for Excel at Installing the Tableau Add-In for Reshaping Data in Excel | Tableau … , or a set of UNION queries or potentially a cross-product query.

The reason why is that to draw the grouped bars, you need a dimension in the data that can split up the measures  so the bar measures can have dates that are slightly ahead&behind the date aggregation, while the line is drawn on the exact date aggregation. Tableau doesn't give us that capability inside of Tableau, so we have to feed data the right way.