Uploaded image for project: 'ONE'
  1. ONE
  2. ONE-34883

Column aggregation can be configured on Overview module - task calculated fields

    XMLWordPrintable

Details

    • Boxes
    • BigPicture, BigGantt
    • JIRA server, JIRA cloud
    • 9
    • 9
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18502"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}
    • Sprint 2021/22, Sprint 2021/23
    • PI2021/6
    • No
    • $i18n.getText("admin.common.words.hide")
      $i18n.getText("admin.common.words.show")
      var cfToHide1 = document.getElementById("rowForcustomfield_18501"); if(cfToHide1){cfToHide1.style.display="none";} var cfToHide2 = document.getElementById("rowForcustomfield_18807"); if(cfToHide2){cfToHide2.style.display="none";} var cfToHide3 = document.getElementById("rowForcustomfield_19700"); if(cfToHide3){cfToHide3.style.display="none";} var cfToHide4 = document.getElementById("rowForcustomfield_18400"); if(cfToHide4){cfToHide4.style.display="none";}

    Description

      Goal: Giving a User flexibility to decide whether tasks in backlog should be included in aggregations on Overview module or not.

      Before change:

      On Overview module, User is NOT able to select aggregation in the columns calculated based on tasks that are in scope of a Box.

      User is not able to exclude from aggregation those tasks which are not in scope of any sub-scope.

       

      E.g. Original Estimate column for PI box sums up the Original Estimate of all tasks in the scope of this PI - even if only a part of the tasks is planned in the Iterations below.

      PI -> Original Estimate tasks sum = 130
        Iteration 1 -> Original Estimate tasks sum = 50
        Iteration 2 -> Original Estimate tasks sum = 50

       

      _____________________________________________________________________________

      After change:

      On Overview module, User is able to select aggregation in the columns calculated based on tasks that are in scope of a Box.

      User is able to exclude from aggregation those tasks which are not in scope of any sub-scope below - depending on preferences.

      E.g. Original Estimate column for PI box can sum up the Original Estimate of:
      A. all tasks in the scope of this PI - even if only a part of the tasks is planned in the Iterations below
      or
      B. only those tasks +planned in the Iterations below

       

      Each field has predefined list of aggregations depending on its data type:
      e.g. Original Estimate:

      Aggregation Comment
       Sum  inluding parent box, so including tasks which are not in any of sub-scope boxes
       Sum, without parent  excluding tasks which are not in any of sub-scope boxes
       Average  inluding parent box, so including tasks which are not in any of sub-scope boxes
      Average, without parent  excluding tasks which are not in any of sub-scope boxes

       

      List of Task calculated fields:

      Task calculated columns Available Display modes Available Aggregations
      Status{} Default Children status categories in %
      Status categories in %
      Time tracking Percentage text
      Progress
      Progress with %
      Remaining as text
      Remaining as lozenge
      Logged as text
      Logged as lozenge
      Original as text
      Original as lozenge
      Sum
      Sum, without parent
      Original Estimate Pretty
      Days
      Hours
      Decimal
      Sum
      Sum, without parent
      Average
      Average, without parent
      Remaining Estimate Pretty
      Days
      Hours
      Decimal
      Sum
      Sum, without parent
      Average
      Average, without parent
      Time Spent Percentage text
      Progress
      Progress with %
      Remaining as text
      Remaining as lozenge
      Logged as text
      Logged as lozenge
      Original as text
      Original as lozenge
      Sum
      Sum, without parent
      Start date Date -
      End date Date -
      Baseline start date Date -
      Baseline end date Date -
      Story Points Lozenge
      Text
      Aggregation X" is selected, so display type is set by default."
      Sum, without parent
      Average
      Average, without parent
      Children status categories in %
      Status categories in %
      Progress Lozenge
      Text
      Aggregation X" is selected, so display type is set by default."
      Sum
      Sum, without parent
      Average
      Average, without parent
      Children status categories in %
      Status categories in %

       

      Attachments

        People

          pawel.wasiak Paweł Wasiak
          mateusz.wyzinski Mateusz Wyzinski
          artur.sedzik Artur Sędzik , system.gerrit Gerrit , kamila.kornatko Kamila Kornatko , pawel.wasiak Paweł Wasiak , dominik.kowalik Dominik Kowalik , marta.kucharska Marta Pastor (Kucharska) , martyna.turowska Martyna Turowska , anna.kicior Anna Kicior , mateusz.wyzinski Mateusz Wyzinski
          Votes:
          0 Vote for this issue
          Watchers:
          3 Start watching this issue

          Dates

            Created:
            Updated:
            Resolved: