Which Gadget to be used for comparing Planned Hours vs actual Hours for each quarter

Shyam Prasad
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 15, 2024

Hi All,

I would like to compare the Planned Saving Hours vs Actual hours delivered in Q1, Q2, Q3 and Q4. I am not sure which gadget to be used to compare planned vs actual hours. I have created a EPIC story and provided hard coded values in Estimated Savings and Actual Savings fields each quarter EPIC and using them in Smart filter but not getting the result. Kindly help!!

 

Shyam

2 answers

2 accepted

0 votes
Answer accepted
Frank Leclerc _Decadis AG_ May 15, 2024

Hello @Shyam Prasad ,

which fields are relevant for the report?

With the date, for example, it makes a difference whether a date from the issue (e.g. Created, Due Date, Start Date, ...) is relevant or a date from the work log.
Do you use the Jira standard functionality for time tracking or a third-party app?
Which fields are then relevant for summarizing at quarterly level? Original Estimate and Time Spent, or others?

For example, the Two-Dimensional Filter Statistics gadget is not relevant if the work log date is relevant.

Cheers
Frank

Shyam Prasad
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 15, 2024

Hi Frank,

Thanks for your reply. I am not using any third-party apps, only using default gadgets. I would like to create a dashboard with Planned Hours vs Actual Hours.

Below is the Example what I am looking for.


                                             Q1          Q2            Q3          Q4

Planned Hours Saving          15,000   20,000     1000

Actual Hours Delivered         12,000   25,000   800

 

Regards

Shyam

Frank Leclerc _Decadis AG_ May 15, 2024

Hi @Shyam Prasad ,

if an app is possible, I can recommend our app sumUp for Jira. We deliver four additional dashboard gadgets in which we provide summarizing functions. For example, we deliver a Two-Dimensional Filter Result gadget, which includes a totals row and column and, more recently, a date functionality in which you can quickly change the time period and the display (e.g. weekly, monthly, quarterly) in the gadget.

Here is an example that comes relatively close to yours:

SCR-20240515-ktuj.png

The important thing here is that these are transaction-related fields.

Maybe you'll give our app a chance.

Cheers
Frank

0 votes
Answer accepted
Annie_DevSamurai
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
May 15, 2024

Hi @Shyam Prasad

Welcome to community!

To compare Planned Saving Hours vs Actual Hours Delivered for each quarter in Jira, the Two-Dimensional Filter Statistics Gadget can be an effective choice. here's a way on how to set it up:

  1. Create a Jira filter that includes the EPICs for each quarter with fields for Estimated Savings and Actual Savings.
  2. Configure the Two-Dimensional Filter Statistics Gadget with this filter. Select a field to represent the quarters on one axis, and configure the other axis to display the sum of Estimated Savings and Actual Savings.
  3. Add the gadget to your dashboard to visualize and directly compare Planned vs Actual hours for each quarter.

I hope this may help! 

Suggest an answer

Log in or Sign up to answer