Time Tracking by Assets Object Field using JQL Custom Charts and Formula Cards in Dashboard Hub

This use case explains how to build a Dashboard Hub dashboard that summarizes Time Tracking fields, including Original Estimate, Remaining Estimate, and Time Spent, grouped by a custom Assets object field. It also demonstrates how to create KPI-style visualizations using JQL Custom Charts and Formula Cards for reporting.

Example scenario

You have an Assets object, for example, Phone009, and want to:

• See a breakdown of time tracking fields for all issues linked to that asset.

• Visualize Remaining Estimate in business days (8-hour workdays).

• Present this using a pivot table and a clean KPI-style formula card.

Part 1: Add a JQL Custom Chart gadget (Pivot Table)

Dashboard Hub’s Custom Charts is a flexible, highly customizable gadget that displays the result of a JQL query or an existing filter, as a table or a chart.

🧭 Step-by-Step configuration

1. Add the gadget
   In your dashboard, click Edit → Add Gadget, then select the Jira Custom Charts gadget.

2. Select the datasource
   Select the required datasource for the asset configuration.

3. Configure the JQL

   project = IOS AND "insight object" in iqlFunction("|"Name\" = \"phone - 009|"*) order by created DESC

   Replace "Assets Object Field" with your actual Assets field name.
   
   

   Open

   

4. Select a View Type:
   Select Table, 1D Pivot Table, or 2D Pivot Table depending on your grouping preference.
   
   

   Open

   

5. Group By (Rows):
   Use the insight object field to group.

6. Fields and Aggregations:

   • Add Time Spent, Remaining Estimate, and Original Estimate using SUM aggregation.

7. Preview Output:
   A table similar to the following example is rendered:
   
   

   Open

   

Part 2: Add Formula Cards gadget for KPI calculation

The Formula Cards gadget enables arithmetic operations on time tracking fields, such as converting seconds to hours or days.

🧭 Step-by-Step configuration

1. Add the gadget:
   In your dashboard, click Edit → Add Gadget, then select the Formula Cards gadget.

2. Select the datasource:
   Select the required datasource for the asset configuration.

3. Create variables:

   • Datasource: Use This Jira instance.

   • JQL:

     project = IOS AND "insight object" in iqlFunction("|"Name\" = \"phone - 009|"*) order by created DESC

   • Field to Aggregate: Remaining Estimate

   • Aggregation: SUM

   • The field returns seconds, so conversion is needed in the formula.

4. Add formula:
   Example for converting seconds to business days:

   (a/ 3600/ 8)

   This gives the result in working days (assuming 8-hour workdays).

5. Customize the card display:

   • Label: Remaining Days

   • Suffix: days

   • Icon: Any, for example, task, clock, or calendar.

   • Card Type: Icon or Donut

     • For Donut: Add a max value, such as 7 (for weekly target).
       
       

       Open

       
       Open

       

6. Save and add more cards:
   Add other variables/cards for:

   • Time Spent

   • Original Estimate

   • Total Workload (custom sum)
     
     

     Open