Sigma #WOW 2025 Week 28

|

Sigma #WOW 2025 Week 28 |

Custom Context Menu

(Unofficial) Solution Overview

Platform: Sigma Computing

Link to original challenge: https://workout-wednesday.com/2025-week-28-sigma-custom-context/

Key Takeaways:

  • Custom Context Menu allows users to select from a list of actions they want to trigger

  • Custom Context Menu differs from On-Click actions because it offers a layer of options for the user to select from

  • Action hierarchy can be defined under a Custom Context Menu

New Additions in this Solution:

  • Added a region filter as a page control to provide an easier comparison than the stacked bar chart

  • Built a hierarchy under the Custom Context Menu to allow

Major Elements Design:

  • Pages

    • Data Page (Hidden)- Store the source table from the Snowflake connection; this table should not be edited.

    • Control Panel (Hidden)- A Master Table created as a Child Element from the Source Table. This table has a dynamic column to return “breakdown by” categories.

    • Modal - Contains a Segmented Page Control and a dynamic pivot table to display the $ context by category selected under the Segmented Page Control.

    • Dashboard - Contains a dynamic title (with reference to date filter), a filter panel, and a bar chart with a Custom Context Menu embedded.

  • Calculations

    • Dynamic Title - To extract the start date of a date page control: DateTrunc("day", [DB-Control-Date].start)

    • Dynamic Title - To extract the end date of a date page control: DateTrunc("day", [DB-Control-Date].end)

    • Control Panel Master Table - To return the value from a dynamically selected column (by the segmented page control): If([MD-Segmented-Category] = "Product Family", [Product Family], [MD-Segmented-Category] = "Store Region", [Store Region])

  • Actions

    • Bar Chart Custom Context Menu

      • Product Family: First, set the value of the segmented control to “Product Family”, then open the modal.

      • Store Region: First, set the value of the segmented control to “Store Region”, then open the modal.

      • Download Context: Download the table as an Excel file

  • Controls

    • Store Region Control: Source from the store region bar chart, target both the bar chart and the pivot table in the modal

    • Date Control: Source from the store region bar chart, target both the bar chart and the pivot table in the modal