Challenge #175: Tire Size Calculator

A solution to last week's challenge can be found here!

Tires: they smell bad and can be expensive, but we all need them. For being a basic piece of technology, they have a huge impact on arriving safely at your destination.
For instance, the "contact patch" refers to the amount of a tire contacting the surface of the road. The size of a contact patch has a huge impact on stopping distance, traction, and even fuel economy. It's a similar story with tire height.

When looking for new tires, it can be useful to get information about a tire's width and height. Many sites have "tire calculators" which allow a user to enter a tire's size in a standard format and view more information on that tire. The standard format for tires is tire width in millimeters, a percentage of that width as the sidewall's height, and the radius of the rim in inches (e.g. 285/70/R17 is a 285mm wide tire, with a sidewall size of 199.5mm (285*.7), and fits on a 17" rim).

For this week's challenge, create a chained app to allow users to enter tire size information and view the additional information on file. Update the next field after the user makes a selection so that only existing options are available.

Your app interface should look similar to this:

Create a three-step app to find tires based on width, sidewall height, and rim radius.

Tire Size Data.yxdb

tire app 1.yxzp

Parse

Apps

Preparation

Advanced

Transform

Interface

Difficult

Accepted answers

All comments

Ladarthure

My solution, no text but the questions in order, great way to learn how to get app running apps

step0.yxzp

JosephSerpis

Challenge Completed

Step 2.JPG Step 3.JPG

Challenge_175_Joe_Serpis.yxzp

NicoleJohnson

My solution! Went with an intro question as well so that I didn't have to have manual inputs in my first drop down (used the first app to create the grouped values for the second chained app to use in the dropdowns).

Spoiler

Cheers!

challenge_175_NicoleJohnson1.yxzp

patrick_digan

Spoiler

step1

step2

step3

Challenge 175.yxzp

rbirch

Solution to challenge #175.

Step 1.yxzp

Reesetrain2

All,

My submission:

Spoiler

I had to rework my submission so that it filtered down the choices.

I used the select/Record ID/Transpose route in order to use convert the remaining choices to headers by adding the record ID.

-If anyone else knows of a better way, please let me know with a @Reesetrain2

-Cheers!

Spoiler

Challenge_175_Reesetrain_Submission.yxmd

Alekh

First chained app challenge?

175..yxzp

Ladarthure

Hi @Reesetrain2, another way to do that is to chain apps, it may be a bit longer to design, but not that hard!

Martyn

Another nice challenge.

Spoiler

Used this template for all 3 apps -

I included the Dynamic Rename as I wasn't happy with the underscores instead of decimal points in the tyre widths (I'm just picky).

Challenge_175_Step_1.yxzp

RolandSchubert

Completed.

Spoiler

TireSelector.yxzp

JamesMA

Great challenge!

Perfect intro to chaining analytical apps! Love it!

Spoiler

I could only include the first part of my solution here though, maybe in the future allow multiple attachments per post?

Hi @JamesMA

If you export your first workflow (Options->Export Workflow), it will package all 3 .yxmz apps together into one .yxzp file allowing you to deploy all three at once.

Dan

danilang

Another fun challenge. What car uses 63.5mm tires?? That's only 1.5mm wider than the largest Lego wheels.

What is it??? a Car for Ants

Spoiler

I went with the field name approach for the first app after getting a unique list of widths

Step 1.png

The second step uses Ratios.yxdb output from step 1 to display the available ratios for the width selected in step 1 and gets the unique Rim Sizes

Step 3 is similar to step 2, but presents the output window at the end

Dan

TireSelector.yxzp

Kenda

Spoiler

step 1

step 2

step 3

step1.yxzp

wwatson

apps saved as workflows enclosed.

Challenge 175 app 3.yxmd

Challenge 175 app 2.yxmd

Challenge 175 app 1.yxmd

ponraj

Here is my solution.

Spoiler

Tire Size Calculator.yxzp

Niklas

Solution attached. Went for a rendered response at the end 🙂

175_Apps_NE.yxzp

ConradW

My Solution for Week 174 - First time using chained apps in a while!

W175 - Solution.yxzp

bnelly1987

Great Challenge! First time doing a chained App!

Spoiler

challenge_175_start_file.yxzp

NicholasM

Loved the challenge, I'll take any chance I get to brush up on chained apps!

W175_NM.yxzp

JORGE4900

Since this was my first time building a chained app, I took this interactive lesson to help me through.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120#done

Here is the main app.

Spoiler

Here is the first chained app for Tire Ratio

Spoiler

Here is the final chained app that shows unique tire descriptions

Spoiler

P.S. Could not attach file

lmorrell

Fun challenge

Spoiler

For some reason, summarising the values from the input at each step of the chain wasn't working on my local machine - so I had to output a few more files to get it working

Also a great bonus from this challenge is going to OPTIONS > EXPORT WORKFLOW to zip up any inputs, outputs, and related workflows as a yxzp. Thanks @AYXAcademy 🙂

Challenge_175_LM.yxzp

Ruud

I see Lego, I click, I'm a simple man. Tried to solve this without chaining apps and using Parameters, but failed miserably 😄

challenge_175_ruud_tired.yxzp

ZenonH

I tried to make use of %temp% directory but found that I couldn't have a chained app reference the files created in the leading application. If anybody knows notation for how I could have accomplished this please let me know (:

The second app would return this error with this input: (directly in the drop-down tool)

%temp%WidthList.yxdb

Spoiler

Initialization and Width.yxzp

hbraunius

My solution attached.

challenge_175_Chained App1.yxzp

zjosephson

My solution

Step 1.yxzp

kelly_gilbert

Fun challenge, and great practice. My solution is pretty similar to @NicoleJohnson's.

Workflows:

Spoiler

Inputs and output:

Spoiler

Output:

challenge_175_solution_klg.yxzp

David-Carnes

OK, this works but I'm sure my method was all wrong. I've used the Interface tools a bunch but not for chaining apps, so this challenge was both illuminating and frustrating.