Write custom formulas using Atlassian Intelligence

[#1]

Hey everyone!

We’re introducing a new Atlassian Intelligence (AI) feature that generates custom formulas based on your prompt. Custom formulas use SQLite syntax and allow you to perform basic calculations or apply one or more functions to your data. With this new AI feature, you’ll be able to write custom formulas without needing to look up SQLite syntax.

Activate AI to get started

AI should automatically be activated for Atlassian Analytics, but if you’re unable to use our AI features, your organization admin will need to activate AI for Atlassian Analytics. More about activating AI.

Start writing custom formulas using Atlassian Intelligence

After your organization admin activates AI, you can start to generate custom formulas for your charts by doing the following:

1. Create or edit a chart, ensuring it has data from an initial query.

2. Add a Formula column or Apply formula step.

3. Select Custom as the formula type.

4. Toggle to AI and then provide your prompt.

5. Select Submit.

AI will then use your prompt and the data in the result table from the Visual SQL step immediately before your “Formula column” or “Apply formula” step to generate a SQLite expression for your custom formula.

Note that AI custom formulas can’t filter or rename columns or perform row-level actions. You’ll need to use the appropriate Visual SQL steps for these transformations.

Here are some example prompts that you can provide:

• 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'

Best practices to generate custom formulas

Make sure to reference the correct columns by putting the column names in quotation marks. The more detailed instructions you provide, the more likely it is that AI will generate a suitable SQLite expression.

Atlassian Intelligence is built for trust

Atlassian takes your privacy seriously, and we work together to handle your data responsibly. Refer to our Atlassian Intelligence Trust Center for more information.