Learn how to connect and manage your connected Atlassian data and external data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
Atlassian Analytics is in open beta
Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.
Perform basic calculations on your column, or combine one or more of functions as needed. SQLite functions are also supported. See the SQLite documentation for the full list of core functions, aggregate functions, window functions, and date and time functions available.
To use a custom formula:
Add a Formula column step or Apply formula step.
Select Custom as the formula type.
Use a built-in or custom SQLite formula.
You can use a column from your result set in a custom formula. Just make sure to wrap the column name in double quotes ("column name"). As you type the column name, it will appear as an auto-complete option if it’s a valid column to use.
You can also use a static string in a custom formula. Wrap the string in single quotes ('static string').
When dividing integers, be sure to multiply the top value by 1.0 to convert your results to a decimal; otherwise, if you’re trying to calculate ratios, you may end up with a bunch of 0s, which probably isn’t what you want. For example:
CASE statements in custom formulas
Use SQLite CASE statements in custom formulas to alter results or perform calculations using conditional logic. Learn more about SQLite CASE statements.
Units for date and time functions
For the formulas mentioned in the next sections, you can use any of the following units in functions involving dates:
quarter (datepart() only)
dayofyear (datepart() only)
There are a variety of built-in functions that appear when creating a custom formula. It shows the parameters for each function, but you’ll need to manually type the values into the field—except for column names, which have an auto-complete feature.
Remember to wrap column names in double quotes (“) and static strings in single quotes (') when you use them in one of these built-in functions.
Some built-in functions are also guided formulas! We recommend using guided formulas, if available. View available guided formulas.
While there are many SQLite functions that aren’t built-in for formula columns, we do support them. You can manually input other SQLite functions into a custom formula, and they’ll work as expected.
Here are some common functions you might use:
acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi, random
length, upper, lower, replicate, instr, substr, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter
stdev, variance, mode, median, lower_quartile, upper_quartile
Was this helpful?