Skip to main content
DD-TRF-001 Basic Data Cleaning and Shaping Get the data →
DD-TRF-001-Q012 Easy

Top region after mapping

Map the Region text in the export through MapRegion to its canonical name. Which region has the highest clean total Amount, and what is it?
Expected
One row: region, total · Ranked bar chart
Tables
FactTransactions, MapRegion · columns
  • FactTransactions
  • MapRegion
  • Region
  • RegionAlias
  • RegionName
  • Amount

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.