Summary of Content

Requirements
The Control Panel
      Opening, Closing, and Resizing the Panel
Control Panel Content
      Totals
      Filters
      Parameters

Requirements

  • You must be a Sigma Creator or Admin to create and manage worksheet controls. Learn more.
  • Worksheet Parameters and Totals are visible to Viewers; filters are not.

The Control Panel

Sigma worksheet controls live in the worksheet control panel, positioned directly to the left of the worksheet table and chart area. This positioning allows you to create and modify your control values while simultaneously watching your data respond in real time.

Opening, Closing, and Resizing the Panel

To open the control panel, click on the CONTROLS bar on the left side of the worksheet or the ‘Show Controls’ button in the toolbar.
37_-_hide-controls.png

The control panel can be resized and closed by dragging the blue hover bar on its right side.

Control Panel Content

Totals

Totals are single value column aggregates that live at the top most level of your worksheet. Calculated worksheet totals can be viewed and selected under the control panel’s TOTALS section. The TOTALS section is only visible if one or more totals exist in the worksheet.

Learn about totals.

Filters

Filters allow you to limit your data to show only rows that meet certain criteria. Worksheet filters can be created and managed under the control panel’s FILTERS section. 

Learn about filters.

Parameters

A parameter is a customizable field that can be added to a worksheet and referenced in formulas. Parameters can be huge assets for What-If Analysis and User Input Analysis. Worksheet parameters can be created and managed under the control panel’s PARAMETERS section.

Learn about parameters.