Challenge #78: Find the Best Housing Markets

[shrestha_nitesh]

Spoiler

 

[tristank]

Considering this challenge is 5 years old I was expecting some differences and got some. Seems like whole states are listed as markets now so there is missing chunks of data, but I am still confident on my approach and solution :)

Spoiler

[Rob-Silk]

My solution below - completed as app:

Spoiler

[Tgigs]

My solution attached.

Cleaning the data was a bit messy, but I got the same result as the posted solution, and tested that the analytic app works with different selections such as value vs units and sorting by different columns.

Also, just to note that the URL is limited to certain dates, for example 201904 works but 202304 does not. So if the user selects a date that is not valid then the workflow will not run successfully.

[olga_strubbe]

Thank you, @NicoleJohnson, for a neat challenge!  It was a great practice of the Multi-Field formula for me which I still struggle at times. 

[asultanov]

Spoiler

[ckoo22]

What a fun challenge, I always love a chance to practice making apps.

[H_a_n_g_C_h_e_n__x3]

Another One

[Carolyn]

Solved, both as a regular workflow and an Analytic App

Spoiler

  

[aatalai]

Liked this one but think there might be a more efficent way will look at other repsonses and solution