Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #78: Find the Best Housing Markets

shrestha_nitesh
Astéroïde
Révélation
Challenge 78 Screenshot 2023-11-27 133400.png

tristank
Bolide

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 :)

 

Révélation
Screenshot 2023-12-11 204606.png
Rob-Silk
Astéroïde

My solution below - completed as app:

 

Révélation
challenge_78a_RS_screencap.PNGchallenge_78b_RS_screencap.PNG
Tgigs
Astéroïde

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.

 

Spoiler.PNG

olga_strubbe
Bolide

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. 

2024-02-01_07-35-14.png

asultanov
Astéroïde
Révélation
Screenshot 2024-02-01 131111.png
ckoo22
Astéroïde

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

H_a_n_g_C_h_e_n__x3
Astéroïde

Another One

Carolyn
Comète

Solved, both as a regular workflow and an Analytic App

 

Révélation
2024-05-07_13-44-12.png2024-05-07_13-43-49.png

  

aatalai
Pulsar

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