This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
Hello - I'm having trouble figuring out how to solve a spatial analytics project. I have created a basic workflow with example data. The business problem is I want to look at business activity for specific dealers on a certain day (July 21st in my example, but would be dynamic in the final product). I want to compare the transactions for dealer Alpha to the other transactions for Alpha...and then the same for Beta's July 21st transactions to the other Beta transactions. Ultimately, I'm trying to verify a dealer's recent transactions are occurring within close proximity (currently set as 0.2 miles) of the past transactions for the dealer. The workflow I created compares the transactions for July 21st for all of the transactions (that weren't on July 21st). I'm thinking I need a Batch Macro to do it and only pass the transactions for a specific dealer at a time to run through the Find Nearest tool. I'm thinking the final output would be any transactions that didn't match within 0.2 miles of any prior transactions...then we could review those to determine if it a new location for the dealer or another reason for the new location.
Thanks Joe, this is really helpful. Eventually I'll be automating this to run each day looking at yesterday's transactions and comparing to the previous 180 days. How do I get around selecting the vendor field each time? Should I switch to an iterative macro that counts how many vendors had transactions yesterdays and then only sends those to the target of the Find Nearest tool?
Thanks again Joe. I was able to work through your example to adjust to make it dynamic for my needs. I hadn't worked with the Control Parameter tool before now. This is a really powerful use case for us and I appreciate your assistance!