AI calculations differ from manually-created calculations only in how they’re created.AI-generated calculations still use Omni supported functions and can be renamed, formatted, and promoted just like a calculation you’d manually create.
Supported functions & formulas
The AI formula builder can use any of the formulas supported in manually-created calculated fields. Refer to the Functions & formulas reference for a complete list of supported functions.Creating AI formulas
Calculated fields can be created in workbooks by clicking the ✨ (three stars) in a workbook. In the left sidenav, this will open the Query helper, but you can also use the calculations bar:1
Open the calculation prompt
In a workbook, click the ✨ (three stars) in the calculations bar:
2
Describe the formula
In the text box, describe the formula you’d like to create. You can include the function to use if you know it, but otherwise, it’s helpful to be specific about what you’re trying to achieve. Refer to the Examples section to get some inspiration.If you’re not sure where to begin, click Get suggestions in the formula prompt window to generate a list of potential starting points:
3
Submit the prompt
When finished, click -> to submit the prompt to AI.If you need to rename the column, you can do so using the column header’s options menu or the table options.
Promoting AI formulas to the shared model
AI-generated calculations can be promoted to the workbook (and then shared) model to allow for reuse. Refer to the Promoting table calculations section of the Table calculations guide for more information.Examples
Two letter abbreviations for US states
Two letter abbreviations for US states
PromptResults table
Using IFS, create a formula that uses the standard two letter abbreviations for US states. For District of Columbia, use DC as the abbreviation.Generated formulaIn the example query, the
A column contains the full name of the state. For example, California or Pennsylvania| State | State Abbreviation |
|---|---|
| Alabama | AL |
| Alaska | AK |
| Arizona | AZ |
| Arkansas | AR |
| … | … |
Extract domain from email
Extract domain from email
PromptResults table
Give me the domain from the email columnGenerated formulaIn the example query, the
A column contains an email address. For example, blobby@blobsrus.com| Email Domain | |
|---|---|
blobby@blobsrus.com | blobsrus.com |
blobross@gmail.com | gmail.com |
bobbyparton@blobbyworld.co | blobbyworld.co |
Identify a date as a weekday or a weekend
Identify a date as a weekday or a weekend
PromptResults table
Tell me if COLUMN_A is a weekday or a weekend.If you receive an error for this prompt, try this instead:
Tell me if COLUMN_A is a weekday or a weekend. If using WEEKDAY, only provide a date as an argument.Generated formulaIn the example query, the
A column contains a timestamp.| Date | Weekday or Weekend |
|---|---|
| 2024-12-27 00:25:19.000 | Weekday |
| 2024-09-30 13:11:47.000 | Weekend |
| 2023-04-27 18:59:25.000 | Weekday |
| 2022-05-15 18:02:33.000 | Weekday |