8 Replies Latest reply on Jul 26, 2013 7:20 AM by Toby Erkson

    Network-Style graph in Desktop Tableau 7.0 Professional Edition

    Mary Howard

      Hi.  I've generated data out of the statistical package R to print coordinates of a network-style graph with circles and points.  The data coming out of R has two files.

       

      File 1: the plot coordinates- these are where the circles of the graph need to be (plotcord.txt):

       

      "","X1","X2","elements"

      "1",-12.4394636137634,-6.75376376401104,"3"

      "2",-9.89248215062783,-24.340757138575,"2"

      "3",28.0805480451123,-18.0979460814945,"2"

      "4",20.9294478675965,-33.5308873579296,"1"

      "5",0.311529024209931,30.4931415555427,"1"

      "6",-11.2861044029133,-3.67750330768594,"0"

      "7",34.6682715653988,-20.731078156846,"1"

      "8",3.88553512359529,-24.5847908281568,"2"

       

      File 2: the lines- these are the connecting lines on the graph (edges.txt):

       

      "","X1","Y1","X2","Y2","midX","midY"

      "33",-5.15423602517631,-14.6975879929801,-12.4394636137634,-6.75376376401104,-8.79684981946986,-10.7256758784956

      "62",-11.8795670405378,-15.1357311265206,-12.4394636137634,-6.75376376401104,-12.1595153271506,-10.9447474452658

      "94",-9.32806808363473,7.23966033930436,-12.4394636137634,-6.75376376401104,-10.8837658486991,0.242948287646661

      "148",-2.3430189428991,-9.77604406965086,-12.4394636137634,-6.75376376401104,-7.39124127833126,-8.26490391683095

       

      What I want to do is draw circles for every x1, x2 coordinate in plotcord.txt, and draw lines from (x1,y1) to (x2,y2) for every coordinate in edges.txt.  But when I start with edges.txt, it does not seem to let me draw lines by putting in the four coordinates of the line.   Is there someway to use this data to draw a network graph?  I can further manipulate the data in R if needed prior to bringing it into Tableau; all I want Tableau to do is use the coordinates that I give it (not generate them).

       

      Attached are the two data sets, and the graph that I want in Tableau (graph generated in R).

       

      -Mary