1 Reply Latest reply on Jul 5, 2017 4:39 PM by Shinichiro Murakami

# Graph Sum(s) of Multiple Measures by Multiple, Respective Dimensions

Hi,

I need help figuring out how to graph multiple measures across multiple dimensions...if this is possible at all. To explain further, here is an example dataset. 0= no, 1=yes, Date (A, B or C) = Date that he/she reached level (A, B or C):

PersonDate ADid he/she reach level A?Date BDid he/she reach level B?Date CDid he/she reach level C?
Bob01/01/2017102/05/2017104/22/171
Joe01/02/2017100
Sam02/05/2017103/15/2017105/14/20171
Sarah03/23/3027100
Megan04/15/2017104/15/201710
Fred05/16/2017100

I would like to create a line graph, were the x axis = time (in days), and the y axis = the sum or # of people to have reached level A, B or C, on that particular day. So, there would be 3 horizontal lines, one line for A, one for B, and one for C. Right now, I have Date A, in days, in the Columns box, and Measure Values in the Rows box, (#A, #B, #C). The issue is that for example, on 01/01/2017, Tableau is graphing a sum of 1 person for level A, and a sum of 1 person for level B, and a sum of 1 person for level C - which is incorrect. It should show, a sum of 1 for Level A, and 0 for levels B and C. I cannot get Tableau to recognize for example, that Bob reached level B on 02/05/2017, NOT on 01/01/2017, unless I plot just Level B data in a separate sheet, by Date B.

Is there a LOD expression or way to plot sum of Level A data by Dimension Date A per day, sum of Level B data by Dimension Date B per day, etc., on one single line graph (with lines for A, B and C)?

• ###### 1. Re: Graph Sum(s) of Multiple Measures by Multiple, Respective Dimensions

Hi Tamara

Unfortunately, Tableau cannot handle this type of data structure directly.

Then you'd better re-shape the data source.

From edit Data source, use Union.

Then combine three data and level info.

Or

FYI

To show zero for Null.

Thanks,

Shin