Connect your data to Atlassian Analytics

Learn how to connect and manage your connected Atlassian data and external data.

Only people who are part of this invite-only early access program have access to Atlassian Analytics.

The “Formula column” and “Apply formula” steps allow you to use formulas to transform your data. You can either use one of our guided formulas or write your own formula using the custom formula option. When adding a “Formula column” or “Apply formula” step, it automatically prompts you to choose a formula type.

When selecting a guided formula, it then prompts you to select values for each required field. There’s also additional text to help you decide which column to choose or what value to input for each field.

If you aren’t seeing a formula type you’d expect to see for an existing column, check the column’s data type. Some formulas are only available for numeric columns.

Guided formulas that perform single-row operations only use the values in one row to produce its result.

Adds a static numeric value to a column

If you want to add a column to another column, you’ll need to use a custom formula.

Divides one column by another in your result set to get a ratio

It automatically converts integers to decimals to ensure decimal accuracy.

First select a column for the numerator, then select a column for the denominator.

Creates a clickable Markdown link in your table chart

First select the text column for the link label, then select the URL column for the link destination. This formula is useful for creating short, easily parsable links.

Calculates the amount of time between two dates.

First select the column with your starting dates, then select the column with your ending dates, then select which time unit to calculate the date difference in (second, minute, hour, day, week, month, or year).

Divides a column by a static value

If you want to divide a column by another column, you’ll need to use a custom formula.

Extracts a specific part of a string

First, select the column to get the substring from. Next, provide the starting position of the substring (1 is the first letter). Lastly, specify a length or leave it empty to include all characters to the end of the string.

If your start and end positions vary, use custom formulas to extract text.

Specifies decimal precision (in other words, the number of decimal places)

This is useful for force-formatting currency.

This guided formula returns a string, not an integer; therefore, it’s best used in table charts or single value charts.

Multiplies a column by a static value

If you want to multiply a column by another column, you’ll need to use a custom formula.

Rounds to a specific number of decimal places

You cannot round a number to a higher decimal precision than it already has. For example, you cannot round the integer 10 to have two decimal places.

Subtracts a static numeric value from a column

If you want to subtract a column from another column, you’ll need to use a custom formula.

Creates a new column where each value is a sum of the values in its row

Guided formulas that perform multi-row operations use the values in other rows to produce its result.

Creates a new column by aggregating the values of another column. Available aggregations options include:

Average

Count

Max

Median

Min

Sum

This is useful for applying calculations to a column that involve an aggregated value. For example, use the “Sum” aggregation then add another “Formula column” step and use the “Column ratio” guided formula to determine a column’s value percentage of the total column.

Accesses data from a previous row in an existing column

**Row offset** defines the number of rows back from the current row to use.

This is useful for comparing the value of a row with the value of the previous row.

Generates a series of averages of your data to create a smooth trend line

**Trailing rows** is the number of previous rows to include in each row’s average.

Determines the percent change between the current and previous row

Determines the percentile of each value in a numeric column

For example, a value is at the 50th percentile if half of the values in the column are less than or equal to it.

Displays each row’s value as a ratio of the column sum (in other words, the row’s value divided by the column’s total sum)

Takes a cumulative sum of all previous results of a column

The general pattern is like this: row1, row1+row2, row1+row2+row3, etc.

Was this helpful?