Free tool ยท Tableau to Sigma
Tableau to Sigma formula translator
Paste a Tableau calculated field and see how to write it in Sigma. LOD expressions and table calculations get a plan, not just a renamed function, because that is where migrations break.
Runs in your browser. Nothing you paste is sent anywhere.
Your Tableau calculation
Start from an example
Sigma version
RestructureRestructure. Min([Order Date])
Min([Order Date])
Where it goes in Sigma
A column at a Customer grouping level. To use it on every row, build a table grouped by Customer and bring it back with Lookup().
What changes
- Sigma has no LOD keywords. The level of detail comes from the grouping a column sits in.
- FIXED ignores dimension filters in Tableau. A Sigma grouping respects workbook filters, so filter-sensitive results can change.
Check after you switch: Compare the result for a few rows with filters on and off.
Function map
The swaps that come up in almost every Tableau workbook.
| Tableau | Sigma | Type | Note |
|---|---|---|---|
| SUM / AVG / MIN / MAX | Sum / Avg / Min / Max | Direct swap | Same meaning. |
| COUNTD([x]) | CountDistinct([x]) | Direct swap | Skips nulls. |
| IFNULL / ZN | Coalesce([x], 0) | Direct swap | One function covers both. |
| DATEDIFF / DATETRUNC | DateDiff / DateTrunc | Direct swap | Unit first, as a lowercase string in double quotes. |
| IIF / IF THEN ELSEIF END | If(cond, value, ..., else) | Direct swap | One If() takes several condition and value pairs. |
| CASE WHEN END | Switch(value, case, result, ..., else) | Direct swap | Same order of arguments. |
| CONTAINS | Contains | Check behavior | Case sensitive. Wrap in Lower() to ignore case. |
| RUNNING_SUM | CumulativeSum | Check behavior | Restarts in each group; follows sort order. |
| TOTAL / WINDOW_SUM | GrandTotal / Subtotal | Check behavior | Pick the level explicitly. |
| {FIXED} / {INCLUDE} / {EXCLUDE} | Grouping levels or Lookup | Restructure | Filters behave differently. |
What this tool does not do
It translates one formula at a time, using the function names in Sigma's documentation, and flags the ones that need a different structure. It does not read workbooks, see your data, or prove the numbers match. That still takes a side-by-side check on the same data.
Moving more than a few workbooks?
Answer 16 questions to see which gaps to close before you scope the move, or talk through your estate.