IMPORTANT: This document is specific to Sigma worksheets. To learn about table columns for Sigma’s new Workbooks feature, please visit Working with Tables.

Columns are central to every Sigma worksheet. When you create worksheets, you will likely structure and format your existing columns, create new column calculations, and sort and filter your data. This article will get you started working with columns in Sigma worksheets.

Summary of Content

Viewing Columns in Worksheets
      The Spreadsheet Interface
      The Column View Panel
Column Details
Working with Existing Columns
      Column Menus
      Formatting Columns
      Sorting Columns
      Moving Columns
      Renaming Columns
      Adding Column Descriptions
      Hide / Unhide Columns
      Delete Columns
      Multi-Column Selection
Creating and Calculating Columns
      Adding a New Column
      Using the Formula Bar

Viewing Columns in Worksheets

When you create a worksheet in Sigma, it will look very similar to the screenshot below. This view provides you two ways to immediately start working with your columns: the worksheet spreadsheet and the column view panel.  When changes are made from one of these two components, your column(s) will automatically update in the other.

Screen_Shot_2020-10-29_at_10.51.18_AM.png

The Spreadsheet Interface

The worksheet spreadsheet interface is centrally located to provide an interactive spreadsheet-like interface. All column actions can be initiated from this table using the column menu.

table-sort.gif

The Column View Panel

The column view panel can be found on the right side of your worksheet. It shows a high level editable view of your worksheet’s columns. Use this panel to search for columns and group data into levels. Like the spreadsheet, each column also has a column menu.

group-column.gif

Column Details

Column details are available for all worksheet column types, except JSON. To see details and statistics about an individual column, open the column menu and select ‘Column Details...’.

Contents of the modal vary depending on column type; however the overarching structure remains consistent.

Screen_Shot_2020-09-18_at_10.06.20_AM.png

About

This section lists column type, name, and formula (fx).

Values

This section displays visual representations of the columns data. The Top Values list contains the column’s most common values. This information is available for Text, Number, and Date columns.  A Value Distribution histogram is also available for Number and Date columns.

Summary 

This section lists key column totals: Values, Nulls, Row Count and Distinct Values. The percent column delineates the percentage of count out of total rows in the column.
Values - The total number of non-null values (see Count)

Nulls - The total number of null values (eg CountIf( [column], IsNull([column])) )

Row Count - The total number of rows in the column, regardless of value

Distinct Values - The total number of unique values (see CountDistinct)

Statistics

This section lists a variety of column statistics. Minimum and Maximum values are displayed for Date and Text columns. These and all other stats listed below are available for Number columns.

Minimum - The column’s minimum value. Depending on column type, this will be the lowest number, the oldest date, or the first Text value when sorted alphabetically (see Min)

25th Percentile - The number of values in the bottom 25th percentile of the columns values (see PercentileCont)

Median - The midpoint in a sorted list of column values. (see Median)

75th Percentile - The number of values in the bottom 75th percentile of the columns values (see PercentileCont)

Maximum - The column’s maximum value. Depending on column type, this will be the highest number, the newest date, or the last Text value when sorted alphabetically (see Max)

Average - The average of all column values (see Avg)

Standard Deviation - The column’s computed standard deviation (see StdDev)

Variance - The column’s statistical variance (see Variance)

Working with Existing Columns

Column Menus

Column menus allow you to directly manipulate your worksheet's data. A few common column actions are sorting, formatting, hiding, deleting, filtering, and aggregating data.

A column’s menu can be found next to the column’s name in the worksheet spreadsheet and in the column view panel. To open the menu, hover over the column name and click the dropdown arrow that appears.

Formatting Columns

  1. Open the column menu on the column you would like to format.
  2. In the dropdown, hover over Format.
  3. Select a format from the submenu.
    Format options are dependent on the column’s value type.

Sorting Columns

Individual columns can be sorted both ascending and descending directly from the column’s menu. Open the worksheet sort modal from any column’s column menu to define multi-column sorting. Learn more.

Moving Columns

Individual columns can be moved using drag and drop. This is possible in both the spreadsheet interface and the column view panel.

move-columns.gif

Renaming Columns

To rename a column, double-click on the column’s name or select Rename Column from the column menu.

Changing the name of a column in Sigma does not change its name in the database.

Adding Column Descriptions

To add or edit a description to a column from the column menu

  1. Open the column’s menu.
  2. Click Add Description.
  3. Enter a description in the text input box.
  4. Click Save.

To add or edit a description from the worksheet toolbar:

  1. Select the column.
  2. Click the description icon in the worksheet toolbar.
    Screen_Shot_2020-10-29_at_11.00.18_AM.png
  3. Enter a description in the text input box.
  4. Click Save.

Viewing Column Descriptions

Columns with descriptions can be identified by a yellow marker in the top left corner of the column header. Hover over the column header to view the description.

Screen_Shot_2020-09-04_at_2.09.58_PM.png

Hide / Unhide Columns

Columns can be hidden using the 'Hide Column' action in the column menu.

Hidden columns are not visible in the spreadsheet. However, they are still visible and actionable from the column view panel. In the column view panel, hidden columns display "grayed-out" compared to their visible neighbors (see 'Billing Country' in the screenshot below).

Screen_Shot_2020-09-08_at_12.22.13_PM.png

To unhide a hidden column, select the 'Unhide Column' action from the column's menu.

You may also choose to use the 'Hide Other Columns' action. This will show the selected column(s) and hide all other columns in the worksheet.

Hidden columns are only hidden from the spreadsheet. They can still be used elsewhere in the worksheet, such as in visualizations, filters, and calculated columns.

Delete Columns

Columns can be deleted using the 'Delete Column' action in the column menu.

Deleting a column will remove any related filters, impact any referencing visualizations, and break any referencing calculated columns

As is the case with all worksheet column actions, deleting a column will not impact the data in the underlying data source.

Multi-Column Selection

Multiple columns can be selected from both the spreadsheet and the column view panel. To select a range of columns, hold down the shift key when clicking the second endpoint in the range. To select and deselect multiple columns individually, hold down as you click each column

To perform actions on your selected columns, open the column menu on any selected column. Not all column actions can be applied multi-selected columns.

multi-select.gif 

Creating and Calculating Columns

Adding a New Column

To inject a new column into the middle of the table, select ‘Add New Column’ from the menu belonging to the column located directly before where you would like to place your new column.

To add a new column at the end of the table or as the last column in a grouping level, click on the associated ‘New Column...’ button in the column view panel.

Screen_Shot_2020-09-04_at_2.21.30_PM.png

Using the Formula Bar

The formula bar is central to calculating data in worksheets. It is located near the top of the worksheet, above the spreadsheet and below the toolbar.

The formula in the formula bar always belongs to the column selected in the worksheet. No formula will be displayed if no columns or multiple columns are selected.

To calculate a new formula, first add a new column. Then type in your formula into the formula bar. As you type, it will suggest auto-completed function names and column names. Once your formula is complete, hit Enter or click the green check to the right of the formula bar. Learn more.

Screen_Shot_2020-09-08_at_1.39.34_PM.png

Related Resources

The Sigma Worksheet
Using the Formula Bar
Popular Functions
Group Your Data

IMPORTANT: This document is specific to Sigma worksheets. To learn about table columns for Sigma’s new Workbooks feature, please visit Working with Tables.