Skip to Main Content
Status Future consideration
Categories Reports
Created by Guest
Created on Jan 14, 2016

Choose unit to display effort values (such as estimates) in the pivot table

If a feature or requirement has an estimate of 5 days, then the corresponding estimate will be count as 40 hours in the pivot table (for example when the requirement's estimated effort is summed as the cell value).  This can result in figures that are less practical to work with, especially when aggregating figures up to the initiative or release level.

It would be better if it was possible to choose the unit, such as days or months.

  • Attach files
  • Patrick Cassiers
    Reply
    |
    Mar 28, 2023

    Would be great to have the initial estimate visualised in all analytics tables so. In my opinion the effort should be either:

    • An option to choose/configure the visualised effort time (converted from the estimate that is)

    • Take the same unit as used in the release (e.g. story points, or mandays)

  • Daniel Pokrývka
    Reply
    |
    Oct 17, 2022

    I just made this idea to be merged with this https://big.ideas.aha.io/ideas/A-I-13290

    I really don't understand, as a software developer, why is this here since 2016! This is a huge shock for me.

  • August Wood
    Reply
    |
    Apr 13, 2021

    We're hoping to replace an excel process for Product Increment planning with a process in Aha, but since we're currently budgeting and estimating in days rather than complexity, having to use hours makes this much harder to work with (especially since we don't plan using an 8 hour work day - we assume more like 5 hours in a working day to compensate for various meetings etc). It would be much more useful if we could choose the unit to display the totals in (in our case days).

  • Dean Packer
    Reply
    |
    Mar 18, 2021

    Having days displayed in hours in meaningless to many viewers of dashboards and shared reports. It's a shame that we are forced to ignore the great Aha! functionality because of this and revert to annoying spreadsheets. Please consider prioritizing this

  • Neal Maeyama
    Reply
    |
    Feb 10, 2021

    Our capacity planning is in days so we would like to see the estimates in days in the pivot table.

  • Allie Emrich
    Reply
    |
    Dec 4, 2019

    I would love to see weeks as an option for capacity planning. We are currently using a custom field to accomplish this.

  • Guest
    Reply
    |
    Nov 8, 2018

    Please note additional issue related to this topic; https://big.ideas.aha.io/ideas/APP-I-6688 - Round report sums to days, weeks, etc.

  • Guest
    Reply
    |
    Nov 8, 2018

    One point of clarification is that our Estimates are established in the system as 'Story Points' - not days & certainly not hours.  So, we would be looking for the Aha! Pivot Report to sum these estimates and present them back as 'Story Points', not days or hours.   

  • Guest
    Reply
    |
    Nov 8, 2018

    Aha! Reports should have standards that present data as data was entered into the system.   We enter estimates in Aha! as story points and in the following scenario Aha! total's them as hours - this is not acceptable!  

    Background as explained by Aha! Support; When time estimates are summed in Pivot reports (like we did in your attached screenshot) they are always summed as hours as a common denominator. 

  • Daniel Rice
    Reply
    |
    Oct 29, 2018

    We would use the pivot to compare Release Capacity vs Estimated Effort, split out by initiative - today the Capacity appears in days and the Estimated Effort cells and totals in hours. The pivot feature seems ostensibly a really useful feature but not usable until you can compare all the numbers directly. I would need them all in days, for instance.

  • +4
4 MERGED

Display estimations as days in pivot table

Merged
Field Feature Original Estimate is populated with number of days value. When presenting features in a pivot table and summing up the values in Feature Original Estimate the result is presented in hours. My immediate request would be to display t...
Guest over 4 years ago in Reports 0 Future consideration
1 MERGED

Effort estimates (Initial or Current) and Actuall effort in DAYS in reporting

Merged
I need to create a pivot report that would sum up all estimates in AHA, but I am unable to do that with Days. Pivot shows only hours. PLEASE HELP
Daniel Pokrývka over 1 year ago in Reports 2 Future consideration