2025 Week 12 | Sigma: Can you save space?

Sigma, Workout Wednesday / By

Introduction

Welcome to Week 12 of 2025!

If you’ve been developing workbooks for long enough, you’ve likely seen end users request a large amount of filters on a single page.  That can take a ton of real estate.  How do you balance the flexibility of a ton of controls with the overall usability of your workbook?  You use a modal!

This week, we’re going to learn how to hide our filters in a modal, using popular movie data sourced from IMDB and found on Kaggle.  

Good Luck!
-Ashley

Need access to Sigma?

Click Here to Sign Up
Link to WOW Sigma Instance
Youtube
Click here to Watch: How to Register & Get Started with Sigma WoW

Note: You will only have view access to WOW Workbooks, Folders, and Workspaces, not edit access. Please create your WOW Workbooks under “My Documents.” We suggest creating a folder to organize all your workbooks. 

Click to Open an Interactive Workbook

Requirements

  • On a hidden Data Tab:
    • First, we want to add our source data.  We need all of the Data Models found in Workspaces / Workout Wednesday / 2025 / 2025W12 – Can you save space? / IMDB
      • Note the Metrics in the main Data Model (2024 Popular Movies) that we will be using:
        • Total Budget:  Sum([budget])
        • Total World Wide Gross: Sum([World Wide Gross])
        • Estimated Profit:  Sum([World Wide Profit])
      • The remaining 7 Data Models are to be used as filter suggestions
  • On a new Modal,
    • Create all of our filters:
      • Note:  I recommend prefixing these filters with “filter-” so they are more easily identifiable in the formula bar suggestions.
      • List style controls are listed below.  The value sources should come from the corresponding text column in either the main data model or the filter suggestion data models.  Targets are not needed for controls pointing to the filter suggestion models.
        • Director
        • Writer
        • Star
        • Genre
        • Production Company
        • Filming Locations
        • Country
        • Language
        • MPAA Rating
      • Slider style controls should all target the main data model, and be sized appropriately for the data in these columns:
        • IMDB Rating
        • Votes on IMDB (target [Votes Numeric])
        • Budget
      • Segmented Page Control targeting [Is Profitable]:
        • The clear option should read “Show All”
      • A Top N filter:  Show Worldwide Gross:
        • This will target the bar graph after it is created
        • Default this to 10
    • Container all filters
    • Title the Modal:  Movie Filters
    • Only include the secondary button, which clears all filters and resets the Top N filter to 10.
  • Update the main data model, so that the filters without targets will filter this table.  You will need 7 calculated columns, one for each of the filters sourced from the other data models (Country, Director, Genre, Languages, Production Company, Star, and Writer):
    • Check if the filter has value:
      • If it has value, check if the array on the main data model intersects with the filter’s array.  If so, return True.  If not, return False.
      • If it does not have value, the column should always return True.
    • Filter each of these new columns to only show True
  • On a visible tab:
    • Create a horizontal bar graph
      • Y-Axis:  Title
      • X-Axis:  Total World Wide Gross
      • Color:  Estimated Profit 
      • ToolTip:  Total Budget
      • Format the X-Axis and Legend to show SI Units with a $ in front, while the full values of these metrics are shown in the ToolTip
      • Show the Legend Header
      • Title:  Top N Worldwide Grossing Movies
        • Use a dynamic value
      • Show the data labels
      • The Top N control on the modal should target this line graph
    • Add a button to open the Filters modal
      • Bonus:  Add dynamic text to the button text to show how many filters have been activated
  • Finishing Touches
    • Give the dashboard a descriptive title
    • Arrange your elements into a cohesive dashboard

Dataset

        • Workspaces / Workout Wednesday / 2025 / 2025W12 – Can you save space? / IMDB
  •  

Share

After you finish your workout, share on LinkedIn, Sigma’s Community page, (or Twitter) using the hashtags #WOW2024 and #SigmaComputing, and tag Ashley Bennett, Eric Heidbreder, Katrina Menne, and Michal Shaffer!

Create an interactive, sharable version of your solution here.

Also, make sure to fill out the Submission Tracker so that we can count you as a participant this week to track our participation throughout the year.

Solution

Coming soon….

Scroll to Top