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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai-interact.html · checked Oct 26, 2026 · quoted by Claude
Streamlit