-
1. Re: From-To analysis without Path Order
Allan Walker Nov 19, 2013 2:41 PM (in response to Alan Roper)1 of 1 people found this helpfulHi Alan,
I get around this by using x,y to line in ESRI, but that's of no help to you. However: if you have a time dimension set up (I see you have some shipment dates in the TDE) you could use that like this (marked in red):
But, your data needs cleansing. I found lots of instances where the city or zip etc weren't being recognized by Tableau. I suggest geocoding your data and using X,Y co-ordinate pairs (and that would also give you a distance calculation).
Best Regards,
Allan
-
2. Re: Re: From-To analysis without Path Order
Alan Roper Nov 21, 2013 7:14 AM (in response to Allan Walker)Allan, I went back and added geocodes to the data set and that enabled me to get "something" on the map. I'm still struggling to get the origin-destination pairs to show as lanes. Any other advice?
-
IB LTL thru P9.twb 71.3 KB
-
3. Re: Re: From-To analysis without Path Order
allan.walker.0 Nov 21, 2013 8:38 AM (in response to Alan Roper)Alan,
I pre-process all my data in ESRI first. If you don't have access to ESRI, then have a look at the work Andy Kriebel did here: VizWiz: Tableau Tip: Create hub & spoke diagrams using the Path shelf - Data Visualization Done Right
Here's my method FWIW:
- Entity|StartLat|StartLong| and union with Entity|EndLat|EndLong;
- Process the points to lines using XY to line in Data Management tools in ESRI (using the Great Circle Arcs);that gives me the lines,
- Then I do ET Wizards Polyline to Point, which gives me path order.
If there is a time dimension, I replace path order.
Best Regards,
Allan
-
4. Re: From-To analysis without Path Order
Kevin Andrist Nov 21, 2013 9:37 AM (in response to Alan Roper)Alan,
Rather than try to figure out what isn't working from your file, see attached. It's a simple example with a screen shot of the Tableau output/setup and the snip of the base excel file. Compare this to the contents & setup of your files and you should see what you need to do.
-
network map example.pptx 1,004.2 KB
-
-
5. Re: From-To analysis without Path Order
brad.earle.1 Nov 1, 2014 3:41 PM (in response to Alan Roper)You'll need to do some custom SQL against your dataset to get the data structured right. You've attached a tde, which doesn't permit doing custom SQL against it. What type of datasource are you using? If a db, then model a small sample into an Excel workbook. Custom SQL works against Excel when you use the 'Open with Legacy Connecton'. The SQL used against an Excel source will be similar structure (but likely slightly different syntax) against your original source db.