Skip to main content

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/171Joe01/02/2017100Sam02/05/2017103/15/2017105/14/20171Sarah03/23/3027100Megan04/15/2017104/15/201710Fred05/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)?

2 answers
  1. Jul 5, 2017, 11:39 PM

    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.

     

    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.

     

    pastedImage_4.png

     

    pastedImage_5.png

     

    pastedImage_6.png

     

    pastedImage_1.png

     

    Or

    pastedImage_2.png

     

    FYI

    To show zero for Null.

    pastedImage_3.png

     

    Thanks,

    Shin

0/9000