Chart logic · Building and maintaining assets

Which BI tools' AI can write chart logic?

10 of 15 tools do, according to their public docs, and 4 partly.

Yes: Databricks, Snowflake, Omni, Hex, Sigma, Looker, Tableau, Power BI, Metabase, MotherDuck. Partly: BigQuery, Alteryx, Mode, Redshift.

The question we asked: Can the built-in assistant write the calculation behind a chart or table in BI content?

Prompt your agent about thisClaudeChatGPT
Grading standard

The assistant writes or changes the calculation behind a chart or table in BI content. Writing SQL in an editor, worksheet or notebook cell is partly.

Databricks

Yes
Quoted from Databricks’s docs"Add a custom calculation to compute the year-over-year growth rate."
Source: docs.databricks.com/aws/en/dashboards/manage/dashboard-agent · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsFor other chart types, ask Snowflake CoWork to change the chart.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/snowflake-cowork/artifacts · checked Oct 26, 2026 · quoted by Gemini
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsYou can add the calculation manually or by using the Workbook Agent.
Source: docs.omni.co/guides/dashboards/calculated-field-filter · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Hex

Yes
Quoted from Hex’s docsGenerate and edit cells: The Agent is capable of creating and modifying Python, SQL, Markdown, Pivot, and Chart cells.
Source: learn.hex.tech/docs/getting-started/ai-overview · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Sigma

Yes
Quoted from Sigma’s docsSigma’s formula assistant uses AI to write new formulas, correct formula errors, and explain existing formulas applied to elements in workbooks and data models.
Source: help.sigmacomputing.com/docs/use-ai-with-formulas · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

BigQuery

Partly
Quoted from BigQuery’s docsYou can generate SQL in the query editor by describing the query that you want in a comment.
Source: docs.cloud.google.com/bigquery/docs/write-sql-gemini · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT yes (preview) · Gemini partly

Looker

Yespreview
Quoted from Looker’s docs- Gemini will display the expression that's created based on your description. You can click Refine to add to or modify your description, or Apply to add the expression to your table calculation or custom dimension definition.
Source: cloud.google.com/looker/docs/gemini-expression-asst · checked Oct 26, 2026 · quoted by GPT
Claude partly (preview) · GPT yes (preview) · Gemini yes (preview)

Tableau

Yes
Quoted from Tableau’s docsManually make your changes in the Calculation Editor and click OK or describe the changes you want to make in the Tableau Agent conversation pane, and let Tableau Agent make the changes for you.
Source: help.tableau.com/current/online/en-us/web_author_einstein.htm · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Power BI

Yes
Quoted from Power BI’s docsChange visuals by selecting new visual types or adjusting their fields.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-create-reports · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Metabase

Yes
Quoted from Metabase’s docsOtherwise, Metabot will use the query builder to create a new chart for you.
Source: www.metabase.com/docs/latest/ai/metabot · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly

Alteryx

Partly
Quoted from Alteryx’s docsAdd tools to your workflow and configure them.
Source: help.alteryx.com/aac/en/ask-alteryx/ask-alteryx-in-designer.html · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

MotherDuck

Yes
Quoted from MotherDuck’s docsEdit the Dive you're viewing. Ask for a change such as "Add a chart of revenue by month," "Change the date filter to the last 90 days," or "Fix the query behind the second chart."
Source: motherduck.com/docs/key-tasks/ai-and-motherduck/agent-chat · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Mode

Partly
Quoted from Mode’s docsWrite calculationsDescribe a new metric or an update to an existing one, have AI Assist write the calculationSELECT --! total sales by rep
Source: mode.com/help/articles/ai-assist · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Redshift

Partly
Quoted from Redshift’s docsChoose Add to notebook to add a Markdown cell with your prompt and a SQL cell with the suggested SQL to your notebook.
Claude partly · GPT partly · Gemini partly

Streamlit

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found