3 Replies Latest reply on Mar 29, 2016 1:37 PM by Ben Moss

    Potential 9.2 Bug - Path Shelf does not connect two dots

    Mason Forando

      Hi All,

       

      I am encountering what I believe is a bug in version 9.2 of tableau and am wondering if it is a result of my setup or a true bug. 

       

      My tableau workbook is shown below.  Essentially I am attempting to accomplish a circular network diagram like this (Note - I know other software can accomplish this easily but would like to use tableau for several related analyses):

       

      Capture.PNG

      Using similar methods to the radial bar chart viz posted here (http://interworks.co.uk/blog/radial-bar-chart/) I am able to draw a start and end point for each transaction/connection at a unique location with an equal distance in a circular layout.  Where transactions/connections occur, multiple points are drawn at the same location.

       

      Capture.PNG

      However, when I add a PathID field (0 or 1 for start and end point) to the Path shelf, Tableau does not draw a line between the two common points for each connection.  The workbook posted below has pages functionality that shows that each transaction/connection is being plotted correctly, and the PathID/RecordID associated with each. 

       

      Is this simply a bug in tableau 9.2, or have I set up the viz erroneously?  Are there any alternative ways to implement a viz like this?

       

      Thanks in advance for any help or advice.

       

      -Mason

       

      https://public.tableau.com/static/images/Ci/CircleLayout/Example/1.png

        • 1. Re: Potential 9.2 Bug - Path Shelf does not connect two dots
          Mason Forando

          One difference I know exists from this workbook to the radial bar chart example on Interworks is that the start and end point have common dimensions across the board, while in this layout I have separate dimensions for each point (i.e. Start Provider Type vs. End Provider Type or Provider Name).  Could this explain the lack of a line between each pair of points?  If this is the case, are there ways to include these dimensions in calculations (i.e. CircleY and CircleX in the workbook) but not in what tells tableau to draw lines?

          • 2. Re: Potential 9.2 Bug - Path Shelf does not connect two dots
            Gabor Burlacu

            Hi Mason,

             

            Please have a look at the network solution that I've posted some time ago: People Network Diagram (https://community.tableau.com/thread/201941).

            I am looking at your viz, and you have a Line chart that only has dots, but not the connections you would like to have. In fact, IMO, the lines are there, those dots are your lines, it's a Line chart, not a Circle chart, the lines are connecting each point to itself. IMO, the fact that you calculate dynamically the X and Y of your points on the circle in the view is nice but it may cause the lack of the lines. Here is an example using some data similar to yours, some small modifications made (in fact the second sheet uses the first 6 Dr., A to F from your data) and each Dr has his circle points X and Y calculated outside Tableau. Another way to do it maybe, have your usual input data stream (for Z doctors), have a second data stream that calculates X and Y on a circle for Z points, and join both data streams in Tableau, so that X and Y are added to your usual input data stream. Hope this helps you!

            Cheers!

             

            Gabi

            • 3. Re: Potential 9.2 Bug - Path Shelf does not connect two dots
              Ben Moss

              Hi Mason,

               

              Just a quick note on how our data should be structured for Tableau to draw path maps

               

              Most of the time our data is structured as below:

               

              Start point     Start Point X     Start Point Y     End Point     End Point X     End Point Y

               

              However, for Tableau to draw the path between two objects the data needs to be as follows

               

                Location                 X                   Y                 Path ID

              Start Point     Start Point X     Start Point Y          1

              End Point     End point X     End Point Y              2

               

              When placing this in comparison with how I believe your data is structured from the following statement:

               

              'while in this layout I have separate dimensions for each point (i.e. Start Provider Type vs. End Provider Type or Provider Name).  Could this explain the lack of a line between each pair of points? '

               

              I would suggest that this probably is the reason as to why there is a lack of a line between your two points. Hopefully the above will help illustrate how your data needs to be set.

               

              Personally when doing these sorts of charts I do all the data preparation (getting the locations of points around a circle for example, and editing the data structure) in alteryx or Excel.

               

              I have written a blog on how you would go about doing so in Excel which might be of help: #VizLikeAnArtist - Hub and Spoke Maps - The Data School

               

              This may also be of help if you are handing with SQL: Tableau Tip: Create hub & spoke diagrams using the Path shelf

               

              Ben