View Transcription


Marcus Montenegro

YouTube Link:

Hello there, my name is Marcus Montengro, and welcome back to another Data in the Wild episode, hosted by Data Meaning. Before we begin, don’t forget to subscribe to the channel below, and click the bell to turn on notifications to be the first to know every time we upload a new video.

Building Centroids in Alteryx

Once you know how to build centroids or a point itself in Alteryx, you can also calculate the distance between these points. So, Alteryx gives you an easy way to calculate this distance. And you’re going to find these two in the special tab and in the distance tool here. So once you push this to your canvas, link it to a data set with points, you can calculate these points.

So, like here in this specific data set, you can see I have 10 rows, and each row is one client with their respective address, I have a certain number here, which is the number of this store, this client bought something from me, and I want to calculate what distance my clients need to go to my store. So, this way, I will know who needs to spend more time to come to my store. And I need to have here the point or the centroid of my client in one column in another column, the point of my store.

Calculating the Difference Between 2 Points

So having these two points, we can calculate the difference between them and calculate this distance. All right. So, after you link your distance to this dataset with these two columns, you’re going to have this configuration. And the first thing you need to configure here is what are your starting point and your destination point. So, what is the source and the destination? In the source you’re going to use your customer point and, in the destination, my story point. Because I want to calculate the distance between my customer and my store points, right?

So here is the first thing you’re going to configure and always these two fields here need to have some data and related coordinates, right. It needs to be a point or centroid, or the destination can also be lines and polygons, all right. Also here, in the rest of the configuration, you have a few more options. So, you can select here to output the distance. And probably you’re going to use that option. But also, you can output the cardinal direction, like, if it goes north, south, or west. And you also can output the direction in degrees.

So, how many degrees goes when going to the destination. All right, you can calculate that as well. And here in the units you can select what units you want to use like miles, and you have a few more options here. Like here I have all these options to calculate to configure how I want to calculate my distance between my point and my polygons. So, if I want to go to the center of this polygon or just to the nearest edge, so all these things you can configure here in this part.

Drive Time Distance Calculation

And if your company has a data set about the drive time distance, you can also use this option and points to this dataset to have drive-time information as well between these two points you want to calculate. I don’t have any here but if you have you can point here and calculate this time. All right. After you finish to configure this distance too, in the anchor output here you’re going to find new columns there, so you’re going to find like here the distance column and with my distance between these two points I selected in the distance too, so now I know how many miles I have between these two points. And they also know the direction, what I go, when I go from my customer point to that store point.

So here, this example, this row 2. I need to go south to go from my customer to my store. Alright, you can know that, and also the distance in the direction degree to go this distance. So, I know exactly the degree I need to curve to go in this direction. Alright, so as example, here I filtered just one store to see the distance from all my clients to this specific store. So, I have key to that store, this number, and if I put that in the browser to see the handler, I can see here in this map, all the head points here, this is my source or my customer points, and the green one here is my destination, so this is my store. And that’s how we can calculate distance between points in Alteryx.

If you have any questions or suggestions for future videos, please comment below. And don’t forget to subscribe to know when future videos are posted. Thanks for watching.

Final Thoughts

Follow Data Meaning on LinkedIn, YouTube and subscribe to our email newsletter for more new content and live webinars.

Would you like more information about how Alteryx can accelerate your analytics? Click the button below to request a free strategy consultation today.

About Data Meaning

For more than 20 years, our management team and consultants have implemented disruptive business intelligence solutions and made bold moves to drive profound business transformations. In partnership with the world’s leading companies and spanning across 15 industries, our team is proud to have struck the balance between industry knowledge and business intelligence expertise to help institutionalize more effective analytically powered business transformations. Thus, the intersection of industry knowledge and business intelligence is not just what we do but is a fundamental part of who we are and what our partnership has to offer.

We deliver end-to-end solutions for our clients and are industry leaders in user experience design, customizations, and training. Start to finish, every project we tackle is focused on delivering the exact intelligence and insight your organization needs to impact performance and achieve the outcomes you care most about.

Get in Touch With Us

Would you like more information about how automating your business intelligence systems can benefit your company? Click the button below to request a free strategy consultation today.

Request Free Consultation