Have you ever wished you could make math calculations with two fields and generate meaningful insights to have in your dashboard? For example, sum specific story points or other custom fields, displaying the one-number result of a two-variable formula.
This is a highly requested functionality among Jira users. In this post, you’ll find answers to discover if this is possible with out-of-the-box capabilities, and how an app can empower you to display the result of math calculations in your dashboards. Let’s dive in!
Does native Jira have any way of doing this?
Unfortunately, Jira doesn’t have the capacity to perform calculations on fields. You can create custom fields to add — like the price per hour of your services — but you can’t calculate the total amount you have to charge for the hours billed in your project.
We can only suggest voting for existing tickets requesting Atlassian implement this gadget. However, Atlassian might never do it.
Luckily, there is a way! There’s an app that includes this functionality.
The Formula Cards gadget for Jira dashboards
Meet the Formula Cards gadget, available in Dashboard Hub for Jira. The Formula Cards gadget enables you to create math calculations on fields, and display the result in either an Icon Card (for numerical results) or a Donut Card a card (for percentage results).
Don’t be scared if you’re not a math person! It’s very simple to configure, and intuitive for all skill levels. The first step is to create up to 5 variables, which store values that can be referenced later in the formula.
Get a more detailed view of the Formula Cards variables, aggregations, view types and configuration in our documentation.
Then, simply create cards. They display the result of a formula expression in a visually appealing way, including two card types: Icon and Donut.
Dashboard Hub for Jira is an app that enhances Jira dashboard’s capabilities by powering up visualization with JQL custom charts, a collection of nearly 100 original gadgets, pre-built dashboard templates, and several integrations. It also simplifies reporting by sharing reports in seconds with secure links, saving hundreds of hours in manual work (Success Solutions customer story), and providing transparency (Unifly customer story).
Check out the Formula Cards gadget in this live Agile dashboard to see a real example. This gadget (like the whole list of nearly 100 Dashboard Hub gadgets) is also compatible with native Jira dashboards, and it can be embedded to your Confluence pages to include dynamic insights and level up your reporting with Dashboard Hub for Confluence.
Pro tip: Dashboard Hub has a free 30-day trial that you can use to build and display some amazing calculations with the Formula Cards gadget. In addition to that, you can try nearly to 100 other gadgets, custom charts, and instant external dashboard sharing.
The Formula Cards gadget gives you possibilities that didn’t exist until now. Fetch the data you need by creating customized calculations easily. If you really need to create customized calculations and report on them, we suggest trying the Formula Cards gadget for free, and see how easy it can be.
Last updated: 2023-06-05