topic Visualize clusters with centroids using Alteryx with Longitude and Latitude values in Alteryx Machine Learning Discussions

Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Tue, 20 Dec 2022 15:10:51 GMT

I need help to Plot the data submission_file_centroids.csv on the map as per attached sample cluster screenshot.

You are only required to address clustering shops (customer_id) around the fulfilment centers.
See attached dataset submission_file_centroids.csv that has the column details.

P.s the longitude and latitude values are for KENYA

A centroid (represents a territory’swarehouse location)

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 15:51:34 GMT

So for each Warehouse, you need to create a cluster/spatial object around all of the customers that it supports? Is this accurate?

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 16:36:06 GMT

@KSowers10 that is correct!

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 16:47:02 GMT

Let me know if this accomplishes what you are talking about! This is an iterative macro that loops through each warehouse location and plots the stores, the warehouse, and creates a convex hull poly.

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 20:06:48 GMT

@KSowers10 thanks, though am unable to open the Workflow you've shared i keep getting below error message

This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 20:14:13 GMT

Right click and open as a notepad, change the highlighted text in the image to be the version that you have of Designer and resave as a .yxmd file:

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 20:58:41 GMT

@KSowers10 See below what i view when i open using notepad

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 21:00:46 GMT

In the meantime are you able to save/share as a .yxmd file ?

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 21:04:24 GMT

That's the zip file, unzip it first with Alteryx (If it lets you) and try to open the .yxmd as a notepad, not the .yxzp.

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 21:09:21 GMT

Still not opening, are you able to share a screenshot of the workflow itself?

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 21:10:54 GMT

Here you go. You'll just have to replace the input data file with yours and then place this macro in the workflow.

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Fri, 23 Dec 2022 21:12:49 GMT

Here's the workflow and the needed macro

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Fri, 23 Dec 2022 21:51:51 GMT

Many thanks @KSowers10 this will work

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

KSowers10 — Sat, 24 Dec 2022 14:11:30 GMT

Awesome!

Re: Visualize clusters with centroids using Alteryx with Longitude and Latitude values

mboroto_89 — Thu, 12 Jan 2023 14:45:18 GMT