2026 Week 13 | Sigma: Fun with Maps

The goal of this challenge is to create a workbook that displays the most profitable counties, with the ability to drill into our map to show the specific stores in a particular county.

Hidden Data Sheet

On this sheet, all we need is a table containing our base data:

• Base Data
  • RETAIL/PLUGS_ELECTRONICS/PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA
• Dimensional Data

  • RETAIL/PLUGS_ELECTRONICS/D_GEOJSON_US_COUNTIES

  • RETAIL/PLUGS_ELECTRONICS/D_STORE

In this base data table, we will need to do lookup data from our dimensional tables:

• • Lookup the store’s Store County
  • Lookup the store’s County Geojson

Create a child table that groups the Store County and Store Region together and calculates the Profit.  Use this as the parent for our bar graph.  Note:  By pre-grouping, we are able to apply a Store Region color to the graph and use a Top N filter effectively.

Finally, create a hidden list control whose value source is Store County.  This should target our Store Map.

Visible Page:

Your visible page should contain:

• • A Bar Graph that shows the Most Profitable Counties with a Region Color 
    • Add an action to filter the Store Map by County and select the Store Map tab in our container if the filter is empty
    • Add another action to clear the filter and select the County Map tab in our container if the filter has value
    • Note:  Because we’re switching tabs, do not allow whitespace to trigger actions
  • Tabbed container with hidden tabs displaying a single map in each tab
    • County Map (Geography):
      • Use the County Geojson as your Geography
      • Add a color scale to show the most profitable
      • Add a tooltip to display the County Name
      • Add similar actions as our Bar Graph
    • State Map (Point)
      • Use the Store’s Latitude & Longitude
      • Add a color by Region
      • Add a size by Profit
      • Add a ToolTip to show all store names at each point
      • Add an action that clears our county control and sets the tab to the County Map
  • Sync the Store Region Color across the Bar Graph and Store Map

Finishing Touches

• Give your visible page a descriptive and dynamic title
• Arrange your elements into a cohesive dashboard
• Update your workbook’s settings to give it a more personalized flair

Tips

• Use a Legend Control to sync the colors across charts to create a consistent user experience.