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):
Person | Date A | Did he/she reach level A? | Date B | Did he/she reach level B? | Date C | Did he/she reach level C? |
---|---|---|---|---|---|---|
Bob | 01/01/2017 | 1 | 02/05/2017 | 1 | 04/22/17 | 1 |
Joe | 01/02/2017 | 1 | 0 | 0 | ||
Sam | 02/05/2017 | 1 | 03/15/2017 | 1 | 05/14/2017 | 1 |
Sarah | 03/23/3027 | 1 | 0 | 0 | ||
Megan | 04/15/2017 | 1 | 04/15/2017 | 1 | 0 | |
Fred | 05/16/2017 | 1 | 0 | 0 |
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)?
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