Write custom formulas using Atlassian Intelligence

Custom formulas use SQLite syntax and allow you to perform basic calculations or apply one or more functions to your data. You can either manually write your own custom formulas or use AI to write your SQLite expressions to help you speed up your chart editing process.

Just like with manually written custom formulas, AI-generated custom formulas only affect the values of one column at a time. However, you can reference multiple columns in a single custom formula to form the SQLite expression (for example, "Column A" + "Column B").

To use AI for writing a custom formula:

1. Add a Formula column step or Apply formula step.

2. Select Custom as the formula type.

3. Toggle on AI.

4. Use natural language to describe the calculations or functions you want to apply to your data.

5. Select Submit.

A “Formula column” step with the generated SQLite expression will be added to your Visual SQL steps. When you edit the step, you can either edit your prompt or toggle to SQLite to edit the generated SQLite expression.

We don’t save your natural language prompt outside of the session that you create it. In other words, if you save your changes to the dashboard and then edit the step again later, only the SQLite expression will be available.

Example prompts

Here are some example prompts you can provide to AI. Column names are wrapped in double quotes, and static string values are wrapped in single quotes.

• Return the first 10 characters of "Column"

• Convert "Column" to a number data type

• The difference in days between "Created at" and "Resolution at"

• Change "Original time estimate (seconds)" to hours

• Change the format of "Date column" to MM-YYYY

• Round "Column" to 2 decimal places

• If "Column" contains 'XYZ' then use 'this value' otherwise use 'backup value'