Challenge #57: Build a Valentine's Day App

Last week's solution can be found HERE!

For this challenge that is taking place on Valentine's Day 2017, build and an app that can find the nearest candy and flower stores near a user-given location. As a result, the application should be able to do the following:
1) Take a map input of a user's location
2) Allow the user to choose between 'florists' and 'confectionaries'
3) Choose if the user wants to find closest distance or drivetime
4) Based on #4, allow the user to input how many minutes or miles are the willing to travel
5) On the output of a map report, allow the user to specify a header
6) Allow the user to specify the directory they want to save the report to

Hint: If the Primary SIC starts with '51' it's a confectionary, if it starts with '59', it's a florist. Be aware that these are Colorado stores only.

For anybody who solves the challenge on or before February 15th, we will be awarded this special badge! If you could not figure out the solution, you can earn the following badge by attending THIS live training, where you can watch how the solution for this challenge was built.

canyheart_action (1).png

challenge_57_start_file.yxzp

challenge_57_solution.yxzp

Apps

Preparation

Advanced

Intermediate

Interface

Spatial

Accepted answers

All comments

MarqueeCrew

Ok! I'll rearrange my calendar and solve this one. I the challenge. If anyone wants to work with me via webex, PM me. I'll be starting this soon.

Cheers,

Mark

paul_houghton

Getting in Early. I think I have this right but I'm never sure if I'm missing something with rendering the output directly to the web browser when running an app from the server.

My solution:

Spoiler

challenge_57_solution.yxzp

MarqueeCrew

Hi @JoeM,

I am working the solution now. I have clarification questions to ask:

Not everyone answering the challenge will have access to drive-time data. Should we answer the question of distance by MILES only? I can create the option to use Miles or Minutes as you describe, but your answer looks like it only allows use of MILES.
Not everyone lives in or near Colorado. I can pretend to live there for the sake of the challenge.

Cheers,

Mark

JoeM

@MarqueeCrew,

1) Yes, since not everyone has the data, raw miles will be fine, DriveTime is a bonus

2) Yes, I should have mentioned that the intention should be that it works for anyone in Colorado, since the stores are all Colorado based. For the purpose of the solution, assume you live anywhere you desire in Colorado. If you have access to the D&B analytical file, you can use that as well!

MarqueeCrew

@JoeM,

I've solved the problem, but had some difficulties.

1. Header macro wasn't found for export.

2. I couldn't figure out how to throw an error message when a pin isn't dropped onto the map input tool.

Screen Shot 2017-02-13 at 4.38.34 PM.png

Here's my take on the output.

Alteryx ChallengeGiftMap.pdf

Challenge_Valentines_Day.yxwz

Max06270

Thank you for this challenge, it is really a great way to stay aware about all tools available. I rarely use the spacial tools.

My solution does not work regarding the 'drivetime' option since I don't have the data-sets, except that I think it does the work.

Spoiler

Happy valentine's day

challenge_57_MK.yxzp

rajiv_tarafdar

Hi Joe,

Thanks for this challenge. It was fun to work on. Sorry it took a while as I got distracted with other engagements.

Here is my stab at the solution.

I have taken a slight deviation to add more value and perspective to this solution.

I found that the output as asked for, did not give the user their location. This makes it hard to spatially recognize the store location in terms of directions and distance. So I added the user's location to the map.

Once I did this, and it showed only the closest result, my label for the user location was completely or partially missing from the map depending on where the closest store was. So I took the liberty to add a question for 'How many stores would you like?' This on most occasions resulted in the user's location clearly being marked.

So finally this is my solution. Hope I have met the requirements.

Alteryx Challenge #57 Interface.PNG Alteryx Challenge #57 Output.PNG

challenge_57_RKT_Solution.yxwz

JeffF

Here is my solution.

challenge_57_JeffF.yxzp

JoeM

The solution is posted. It was great to see people not only successfully doing the weekly challenge, but doing it BETTER. There were some well-styled maps and some great error handling logic put into this week's challenge!

SeanAdams

no where near as polished as some of the submissions, but it seems to work

(not as pretty on the canvas as @MarqueeCrew either).

As long as the flowers arrive, it should all work out OK...

challenge_57_seanSolution.yxwz

NicoleJohnson

My solution. This was a fun one! Learned a lot more about apps, and a few things about maps... I solved without DriveTime parameter as I don't have the dataset, so no bonus for me. But I did randomly try out wireless connections for my app prompts so that there weren't lines all over the place, which certainly makes the canvas look prettier... so that has to be worth at least one candy heart.

Spoiler

challenge_57_NicoleJohnson.yxwz

estherb47

Nothing innovative in my solution.

Is there a way to only load in a map of Colorado?

challenge_57_EHB_solution.yxwz

Natasha

@estherb47

To zoom onto a specific place on an input map, the tool needs to be configured the following way:

Screen Shot 2017-06-06 at 15.07.15.png

Natasha

A bit too late for Valentine's Day but was a good opportunity to brush up on interface tools.

Since I don't have a drive package, I decided to add an option for a user to choose between Miles and Kilometres. Though on the second thought, there is not much difference between them

Spoiler

challenge_57_NK.yxwz

LordNeilLord

Those reporting tools are a bit fiddly but a fun exercise

Spoiler

challenge_57_LNL.yxzp

patrick_digan

Fun challenge!

Spoiler

challenge_57_start_file.yxwz

nick_ceneviva

Great Challenge! Solution attached.

challenge_57_Ceneviva.yxwz

samN

Spatial challenges live up to their name for me. Also dont have driving data but kept the option in there in case i added it later or something.

challenge_57.yxzp

ggruccio

Haven't used apps much - this was a great training exercise.

challenge_57_gg_finish.yxzp

LandonG

Solution attached.

challenge_57_start_file.yxzp

philipmannering

Solution attached.

Spoiler

The app

challenge_57 - Build a Valentines Day App.yxwz

jasperlch

A very good test on analytical apps and map tools! Solution attached.

challenge_57_JL.yxzp

JosephSerpis

Challenge Completed

Challenge_57_Joe_Serpis.yxwz

dsmdavid

Not a fan of the reporting tools...

solved#57.yxwz

jamielaird

Here's my solution... just in time for this year's Valentine's Day challenge.

Spoiler

challenge_57_solution_JL.yxzp

daniel_ferreira

Follow my solytion app attached...

challenge_57_solved.yxwz

luciebrett

Here is my attempt.

challenge_57_LB.yxwz

danilang

Mmm. Candy! no drive time data though, so no drive time/distance selector. It's all miles!

Spoiler

Dan

challenge_57_solution_DL.yxwz

kat

Spoiler

Challenge #57.yxzp

OldDogNewTricks

Here is my solution. A lot of firsts for me on this one: first Analytic app, map interface, map input, report map, report header, and report render. Wow...

Is anyone aware of how to change the size of the map presented to the user in the map interface tool? I found that to be a really small map to work with and present to users when the Analytic app is run.