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 #269: Population DenCities

tristank
11 - Bolide

Did the beginner and intermediate ones. Had no idea what weighted avgs were so I found a lovely macro from Chaos Reigns Within. (Thanks Adam Riley) I don't play around with the spatial match often so it was cool to see how I could effectively use it as a join to identify the countries the various cities were in.

 

Spoiler
Screenshot 2023-08-02 132729.png

 

NMangera
10 - Fireball

workflow.png

 

takeaway

1. tool: spatial info. Go from a spatial object to centroid/co-ordinates

2. design pattern: under the reporting palette. Layout tool often preceded by join of table/map...etc

gawa
15 - Aurora
15 - Aurora

I'll come back to solve al level since my weakness lies in spatial analysis field.

 

Dani_Lin
8 - Asteroid

solved

anabelvelazque
8 - Asteroid

Hi! Here is my take :-)

 

Spoiler
Screenshot 2023-09-25 182438.png
Dani_Lin
8 - Asteroid

solved

alacoume
8 - Asteroid

Done begginer and intermediate

networkmike42
8 - Asteroid
Spoiler
Screenshot 2023-11-01 171254.png

asultanov
8 - Asteroid

Basic & Intermediate

Spoiler
Screenshot 2024-02-15 142205.png
danbostrom
8 - Asteroid