13 Replies Latest reply on Dec 20, 2016 1:37 PM by Matthew Risley

    Help with plotting a line graph to identify a relationship

    Emma Lonergan

      Hello All!

       

      I undertook a questionnaire at work and I would like to plot the results from 4 of the statements in a graph. Each statement having a different colour as to differentiate between them.

       

      I would like to create a graph like the one below which i found online - But I cant seem to get it to do this. This is just an example of what I am attempting to do.

       

      So the coloured lines would represent each of the 4 statements, then length of time working for the company (1-5) on the x-axis and Rating they gave for each statement (1-9) on the Y-axis.

       

      This will then enable me to see if the response or rating given to each of the statements has a relationship with the length of time the person has worked for the company.

       

      I am seriously struggling to do what seems like it should be simple, can anyone help me here?

       

      Below is the dataset i am trying to work with. I have also attached the dataset i am trying to use in Tableau, as well as the packaged workbook. I have been at this all day and am no further along. Please can someone please help me!

       

       

          

      Respondent numberLength of time with companyEffective (Q4)Training (Q4)Speed (Q4)Reliable (4)
      217777
      418746
      636587
      717777
      824823
      917577
      1127777
      1349937
      1537768
      1727899
      1848886
      1947731
      2127755
      2237337
      2447777
      2537877
      2819188
      2926325
      3027733
      3137867
      3217346
      3547833
      3747133