Tempo logotype

How our updated Formulas language unleashes more data for easier decision-making

Update brings significant Formula language improvements that help users efficiently extract vast amounts of data from Jira. Here, we discuss how it can shed light on your projects with much less effort.
From Team '23

Tempo Team

Originally published June 29, 2021

The latest on-prem version of Structure PPM dramatically improves the accessibility of Jira data, so you can create clearer visibility into your projects. You can catch warning signals earlier and make better, faster decisions as a result.

How? We’ve taken one of our best features, Formulas, and put it on steroids! More functions, easier access to even more data, just straight-up more.

This means you can use things like issue links, work logs, related epics or stories, parent tasks or sub-tasks, additional properties within versions or sprints, and a host of other items you couldn't readily access from your formulas previously. You can extract data from these values and efficiently assemble project metrics, indicators, and other values.

Here are some examples of how organizations might use these new capabilities.

Get clearer insights — with less work

Say you want to get a prediction date for when a team will finish an epic. To do this, you need to find the finish date for stories on the epic level. In prior versions of Structure, you would have to create structures that included all the related stories. With Expr 2.0, you don't need to.

Expr 2.0 lets you query information from issues linked to those present, without needing to build structures that include everything. There's no need to build a massive structure with all the stories in it — because the stories are linked to your epic, you can query the information and get the answer.

You accomplish this simply with (be sure to set the format to date/time):

MAX(epicStories.sprint.endDate)

With Expr 2.0, you can answer all sorts of questions, such as: How many unresolved issues are blocking this other issue? How many blocking dependencies are in another project? Is this issue blocking other projects — and if so, which ones? And you can do it without putting in the time and energy into creating large, complicated structures to get that data.

Perform statistical analysis without extra tools

Another example: Say you want to analyze team performance — specifically, you're interested in team velocity, and want to spot any anomalies that indicate a team is struggling.

You can answer this question with Structure 7 — without having to export data to Excel (or any other tool) to do the calculation. You can calculate the mean story point estimate for all issues, as well as interquartile range, to see the estimated work variance as well as the same calculations on work logged for those issues.

To calculate the interquartile range you would simply write:

WITH points = ARRAY { storyPoints } : QUARTILE(points, 3) - QUARTILE(points, 1)

This uses a local variable, points, to hold all the story points of the children.

Or, suppose you want to analyze which tasks are getting neglected as they get lost in the handoff between teams. Many organizations see cycle time grow because teams aren't tracking tasks that aren't anyone's official responsibility. Now, you can better understand that situation by calculating the 5th and 95th percentile for issues in statuses like "transitions from submitted to investigating" or the range of time in "testing," or "in review."

Learn more about Expr 2.0

Those examples just scratch the surface of what Expr 2.0 enables users to do. This system is robust and flexible enough that users can take these capabilities and apply them to their own unique situations, finding the best and most innovative uses all on their own. We built this software, now users can go and do truly awesome stuff with it.

There are a number of resources to help users understand what Expr 2.0 does and get ideas for how to apply it. We suggest you bookmark the Formulas page on our Structure wiki, which includes:

As always, our support team is available to get you over any obstacles. Please don't hesitate to reach out if you get stuck. We'll gladly help you unlock the power of these improvements!

Sign up for a demo

Register

Explore More Content

Unified time and team management

Integration: Timesheets and Capacity Planner

Seamlessly manage project timelines and resources while accurately tracking time spent on tasks. This integration enhances visibility, improves planning accuracy, and supports data-driven decision-making for better overall project outcomes.

Learn more

AI-enabled capacity visualization

Capacity Insights - Open Beta

Deliver visibility into how your team's time and efforts align with business objectives and project ROI - without the manual effort

Learn more

Jira Portfolio Management PPM

Structure by Tempo

Jira Project Portfolio Management (PPM): Visualize data and manage projects within spreadsheet-like tables — in less than a minute

Go to marketplace
Colleagues interacting around a desk

No-Code Power BI Jira Integration

Power BI Connector for Jira

Effortlessly bridge Jira with your preferred BI tool, unlocking unparalleled insights and enhancing decision-making

Learn more

Monitor financial health at every level

Financial Manager for Timesheets

Monitor projects and portfolios to get simple, clear, and real-time views of your costs, budgets, and profits that can be shared throughout your entire organization.

Learn more

Jira Team & Resource Management

Capacity Planner

#1 Jira Resource Management App: Optimize team allocation, skillset utilization, capacity planning & project management

Go to marketplace

Real-time collaboration and capacity planning in Jira

Capacity Planner

A powerful team resource management tool designed to optimize capacity planning and project management in Jira

Learn more

Roadmapping software for teams of all sizes

Strategic Roadmaps (Roadmunk)

The roadmapping tool designed for high-performing teams delivering boardroom-ready strategic roadmaps.

Learn more

Align your organization with proactive portfolio management

Portfolio Manager (LiquidPlanner)

Predictive scheduling and the ability to forecast project timelines and spot risks so you can meet deadlines with confidence.

Learn more

Industry-leading project plan and roadmap visualizations with a Gantt chart extension

Gantt Charts for Structure PPM

Visualize project plans and roadmaps with a Gantt chart extension for Jira

Learn more

Project and program management for Jira

Structure PPM

Visualize all your Jira data & manage portfolios of projects in real-time.

Learn more

Unified time and team management

Integration: Timesheets and Structure

Combining Tempo Timesheets and Structure PPM provides a unified view of time tracking and project progress, enabling more accurate reporting and effective portfolio management. Simplify workflows, enhance collaboration, and ensure projects stay on time and within budget.

Learn more

Jira ITSM Solutions with Tempo

ITSM

Build and scale a custom ITSM solution at your own pace with Tempo's modular suite of integrated tools. Enhance Jira's capabilities and take control of your entire IT portfolio.

Learn more

Centralize real-time plans in one view

Integration: Structure and Gantt Charts

Gain a more complete project management solution, simplifying project reporting, improving collaboration, and ensuring projects stay on time and within budget.

Learn more

Custom charts and dashboards for Jira

Custom Charts for Jira

See how work is progressing and where blockers are with the most flexible reporting app in Jira.

Learn more

Jira Project Cost Tracking

Financial Manager

Project financial management for Jira & Timesheets. Monitor project costs, expenses, revenue, billing & budgets. Track Capex/Opex

Go to marketplace

Powered by Structure’s custom hierarchies, visualize your roadmap, project plans, timeline & dependencies within Jira Gantt charts

Go to marketplace

Strategic Portfolio Management

Strategic Portfolio Management

Modern modular PPM solutions that scale with your business. Align your teams with the integrated platform that bridges the gap between strategy and execution.

Learn more

No more reporting limitations

Custom Charts for Confluence

Create and share all kinds of highly visual and customizable charts directly on your Confluence pages.

Learn more

Take control of your projects

Integration: Portfolio Manager and Jira

Portfolio Manager integrates seamlessly with Jira to give you predictive scheduling, real-time scenario modeling, and advanced resource management – ensuring you stay on track, no matter what challenges arise.

Learn more

Time Tracking Software for Jira

Timesheets

Tempo’s intuitive automation and Jira-native design make it the most trusted time tracking tool for enterprise organization.

Learn more

Never lose track of a brilliant idea again

Idea Manager for Strategic Roadmaps

Never lose a brilliant idea again. Idea Manager for Strategic Roadmaps has built-in best practices to help.

Learn more

Jira Time Tracking

Timesheets by Tempo

#1 Jira Time Tracking & AI Apps: Log Tempo Timesheets for Planning, Project Management & Billing. Plugin Office365, Google & Slack

Go to marketplace

Agile at Scale Software

Agile at Scale

Adapt to changing business needs, rapidly adjust plans, and reallocate investment.

Learn more