Jump to Content
Documentation
What's New
Home
Community
QuickStarts
Status
Home
Community
QuickStarts
Status
Moon (Dark Mode)
Sun (Light Mode)
Documentation
What's New
Search
Loadingβ¦
Start
Get around in Sigma
Search in Sigma
Sigma basics
Templates
Get started with workbook templates
Create workbooks from templates
Create and edit workbook templates
Share workbook templates
Share and accept cross-org workbook templates
HubSpot Campaign Analysis template
Snowflake usage templates
Prep
Connections
Connect to data sources
Snowflake
Connect to Snowflake
Configure user attributes on a Snowflake connection
Configure an export warehouse
Databricks
Connect to Databricks
AlloyDB
Connect to AlloyDB
BigQuery
Connect to BigQuery
MySQL
Connect to MySQL
PostgreSQL
Connect to PostgreSQL
Redshift
Connect to Redshift
Connect through SSH
Set up write access
Configure Warehouse Data Editing (Deprecated)
AWS PrivateLink Connections
Azure Private Link Connections
Troubleshoot your connection
Sigma's Sample Connection
CSV uploads
Upload CSV data
Input tables
Intro to input tables
Create and manage input tables
Edit existing input table columns
Create AI-enhanced input tables (Beta)
Joins
Join types
Lookup join
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Join Data in Datasets
Join data in workbooks
Transformations
Define custom datetime formats
Generate and access structured objects
Model
Data models (Beta)
Intro to data models (Beta)
Create and manage data models (Beta)
Datasets
Dataset best practices
Introduction to the Dataset Worksheet
Dataset worksheet controls
Dataset Worksheet Columns
Model data from database tables
Data modeling tutorial
Using CSVs in Datasets
Dataset Lineage
Share datasets
Configure Dataset Columns
Dataset Links
Dataset Totals
Dataset filters
Create and manage dataset parameters
Advanced modeling topics
Hierarchies (Beta)
Dataset Row-Level Security
Edit Warehouse Data from Sigma (Deprecated)
Analyze
Workbook basics
Workbooks overview
Workbook lifecycle: explore, draft, and publish
Workbook modes overview
Workbook settings overview
Intro to Element Types
Workbook management
Create a workbook
Create and manage workbook layouts
Edit, draft, and publish a workbook
Copy and paste workbook pages (Beta)
Copy and paste elements
Manage workbook page visibility (Beta)
Manage workbook refresh options
Data elements
Intro to data elements
Create a data element
Use linked columns in workbooks
Tables
Create and manage tables
Working with pivot tables
Wrap text
Pivot table subtotals
Add hyperlinks to columns
Extract columns from JSON or variant data
Visualizations
Intro to visualizations
Build a bar chart
Build a line chart
Build a KPI chart
Build a scatter plot
Build a Sankey diagram
Build a funnel chart
Build a gauge chart
Build a geography map (Beta)
Area charts
Combo charts
Box and whisker charts
Pie and donut charts
Maps
Create and format trellis charts
UI elements
Intro to UI elements
Create a one-click action button
Text elements
Use your organization's plugins
Controls and filters
Intro to control elements
Duplicate controls
Synced controls
Drill down control
Segmented control
Top N filter
Create flexible reports with parameters
Parameters in workbooks
Data element filters
Apply control values with URL parameters
Create a hidden control
Sort filter values
Guided workflows
Create and edit period-over-period analysis
Add columns through Lookup
Customize
Workbook actions
Intro to actions
Create actions that navigate to destinations
Create actions that manage control values
Create actions that modify or refresh elements
Create actions that download and export data
Create cross-element filters
View and manage existing actions
Workbook elements
General element formatting
Customize element background
Customize element title
Table customization
Customize table style
Format pivot table totals (Beta)
Visualization customization
Customize chart mark tooltip fields
Format chart legend
Display chart data labels
Display chart reference marks
Add trend lines
Configure custom sort
Workbook security
Configure column-level security
User Attributes
Localization
Manage workbook localization
Collaborate
Live edit
Collaborate with Live Edit in workbooks
Document sharing
Share a folder
Share a workbook
Workbook comments
Use comments in workbooks
Capture and annotate images in comments
Workbook badging
Add or update a workbook badge
Explore
Data interactions
Ad hoc data explorations
Explore a published workbook
Leverage an explored workbook
Highlight chart values
Drill into data (Drill Anywhere)
Data transparency
View workbook data lineage
View underlying data
View column details
Workbook versions
Workbook versions and version history
Bookmarks
Create and manage bookmarks
Export
Downloads
Download a workbook page
Download or export a data element
Schedules and on-demand send
Send or schedule workbook exports
Schedule a conditional export or alert
Manage scheduled exports
Export to email
Export to Slack
Export to Google Sheets or Drive
Export to cloud storage (Beta)
Export to webhook (Beta)
Format PDF exports (legacy layouts)
Apply control values to scheduled exports
Calculate
Operators overview
Functions
Popular functions
Aggregate functions
Aggregate functions overview
ArrayAgg
ArrayAggDistinct
Avg
AvgIf
Corr
Count
CountDistinct
CountDistinctIf
CountIf
GrandTotal
Max
MaxIf
Median
ListAgg
ListAggDistinct
Min
MinIf
Ndv
PercentileCont
PercentileDisc
PercentOfTotal
StdDev
Subtotal
Sum
SumIf
SumProduct
Variance
VariancePop
Array functions
Array functions overview
Array
ArrayContains
ArrayDistinct
ArrayLength
ArraySlice
Date functions
ConvertTimezone
DateAdd
DateDiff
DateFormat
DateFromUnix
DateLookback
DatePart
DateParse
DateTime
DateTrunc
Day
EndOfMonth
Hour
InDateRange
InPriorDateRange
LastDay
MakeDate
Minute
Month
MonthName
Now
Quarter
Second
Today
Weekday
WeekdayName
Year
Financial functions
Financial function overview
CAGR
Effect
FV
IPmt
Nominal
NPer
Pmt
PPmt
PV
XNPV
Geography functions
Geography functions overview
Area
Centroid
Distance
Geography
Intersects
Json (geography)
Latitude
Longitude
MakeLine
MakePoint
Perimeter
Text (geography)
Within
Join functions
Join functions overview
Lookup
Rollup
Logical functions
Logical functions overview
Between
Choose
Coalesce
If
In
IsNotNull
IsNull
Switch
Zn
Math functions
Math functions overview
Abs
Acos
Asin
Atan
Atan2
BinFixed
BinRange
BitAnd
BitOr
Ceiling
Cos
Cot
Degrees
DistanceGlobe
DistancePlane
Div
Exp
Floor
Greatest
Int
Least
Ln
Log
Mod
MRound
Pi
Power
Radians
Round
RoundDown
RoundUp
RowAvg
Sign
Sin
Sqrt
Tan
Trunc
Passthrough functions
Passthrough functions overview
AggDatetime
AggGeography
AggLogical
AggNumber
AggText
AggVariant
CallDatetime
CallGeography
CallLogical
CallNumber
CallText
CallVariant
System functions
System functions overview
CurrentTimezone
CurrentUserAttributeText
CurrentUserEmail
CurrentUserFirstName
CurrentUserFullName
CurrentUserInTeam
Text functions
Text functions overview
Concat
Contains
EndsWith
Find
ILike
Left
Len
Like
LPad
Lower
LTrim
MD5
Mid
Proper
RegexpExtract
RegexpMatch
RegexpReplace
Repeat
Replace
Reverse
Right
RPad
RTrim
SplitPart
StartsWith
Substring
Trim
Upper
Type functions
Type functions overview
Date
Json
Logical
Number
Text
Variant
Window functions
Window function overview
CumulativeAvg
CumulativeCorr
CumulativeCount
CumeDist
CumulativeMax
CumulativeMin
CumulativeStdDev
CumulativeSum
CumulativeVariance
FillDown
First
FirstNonNull
Lag
Last
LastNonNull
Lead
MovingAvg
MovingCorr
MovingCount
MovingMax
MovingMin
MovingStddev
MovingSum
MovingVariance
Nth
Ntile
Rank
RankDense
RankPercentile
RowNumber
Metrics
Create and manage metrics
Use metrics in a workbook
Query
SQL queries
Examine dataset queries
Examine workbook queries
Write custom SQL
Set a query ID cache duration
Caching and data freshness
Materialization (Beta)
Warehouse views
Create and manage dataset warehouse views
Create and manage workbook warehouse views
EMBED
Intro to embedded analytics
Public embedding
Create and manage a public embed
Secure embedding
Create a secure embed
Generate embed client credentials
Generate a secure embed path
Example embed API and URL
Embed URL parameters
Test an embed URL in the embed sandbox
Common embed error codes and messages
Advanced data security in embeds
Implement column-level security in embeds
Implement row-level security in embeds
Apply dynamic connection and role switching to embeds
Enable OAuth for embeds
Additional embedding configurations
Implement actions and events in embeds
Manage iframes for embeds
Develop
Sigma API
Get started with Sigma's API
Generate API client credentials
API authentication with cURL
Sigma's Swagger playground
Identify unique IDs in Sigma
Plugin development
Get started with custom plugins
Develop plugins for Sigma
Plugin development API
Plugin examples
Admin
Administration portal
Access the Administration portal
General settings
Enable a custom homepage
Change the account time zone
Enable or disable CSV upload
Enable or disable account upgrade requests
Enable or disable comments
Manage annotated image ability and storage period
Manage Slack integration
Manage dbt Integration
Manage OpenAI integration
Register a Plugin with your Sigma Organization
Create reusable custom functions
Branding settings
Upload custom fonts
Create and manage workbook themes
Customize email branding
Authentication
Manage authentication
Single sign-on with SAML
Two-Factor Email Authentication
OAuth with Snowflake
OAuth with Snowflake and Azure AD
Configure OAuth with write access (Beta)
Manage Users and Teams with SCIM
Manage Users and Teams with SCIM and Okta
Use custom account types with your IdP
Custom Session Timeouts for Okta
Restrict Export Recipients
Usage
Usage overview
Document Activity Dashboard
Document Permissions Dashboard
Scheduled exports dashboard
People
Manage People
Customize Welcome and Invite Emails
Invite people to your organization
Manage Users with User 360
Guest User Accounts
Impersonate users
Deactivate users
Teams
Create and manage teams
Manage team members
Manage team admins
Manage Workspaces
Permissions
License and account type overview
View license utilization
Create and manage account types
Basic explore vs. Full explore
Data permissions overview
Manage data permissions
Folder and Document Permissions
Tags
Version Tagging
Scheduled exports
Manage Organization Schedules
Warehouse views
Review warehouse view details
Audit log
Enable audit logging (Beta)
Access and explore audit logs (Beta)
Audit log events and metadata (Beta)
Create an audit logs storage integration (Beta)
Export audit log data to cloud storage (Beta)
Document management
Recover deleted documents
Reference
Additional resources
Region, warehouse, and feature support
Download, export, and upload limitations
Keyboard shortcuts: Mac OS
Keyboard shortcuts: Microsoft Windows
Special characters for URL parameters
Data type and format support
Best practices for improved performance
Contact
Sigma support
Submit a support request
Escalate critical issues
Workbook analysis
Suggest Edits
Updated 6 months ago