This article is for Structure Data Center.
Question
I want to create or adjust a formula in my structure.
Answer
Based on your setup and the formula’s requirements, you might find useful information for creating the formula you need in these materials:
-
Some examples of already working formulas: https://help.tempo.io/structure-dc/latest/sample-formulas
You might find a formula that you need there, or a similar formula that can be used as a base, and adjusted with your specific data. You might also find one of the bundled formulas useful: https://help.tempo.io/structure-dc/latest/bundled-formulas -
Available standard functions - these functions can be used for creating custom values based on each item’s own data: https://help.tempo.io/structure-dc/latest/expr-function-reference
These functions can be directly used with numeric, text, date & date/time, and duration types of values. -
Available aggregate functions - these functions can be used for summing up/rolling up the data across the levels of the hierarchy, or for creating custom values of parent items based on the data of their children: https://help.tempo.io/structure-dc/latest/aggregate-function-reference
-
Item properties - these functions can extract additional data tied to certain field values in Jira: https://help.tempo.io/structure-dc/latest/item-property-reference
With these properties, you can display properties such as: Start & End dates of Sprints; Component lead; authors, and posting dates of Comments; attributes of worklogs: authors, dates, logged hours of specific users in specific time periods; historical data of work items, and more. Also, the properties of the issuelinks allow filtering through linked work items and extracting some data from linked items. -
Formatting with Wiki markup for adding visuals to the column - coloring, images, and emojis, and highlighting certain values in the way you need: https://help.tempo.io/structure-dc/latest/wiki-markup-in-formula-columns
If you still need assistance after exploring the materials mentioned above, please let us know, and we will look into it. Please describe what you want a formula to display as a result, as well as screenshots of your structure.
It’s often impossible to provide any recommendations without understanding the context around the formula, so please make sure to provide as many details as possible: about the formula you need and the data you want to use for calculation, and the description of your setup.