2 Replies Latest reply on Apr 3, 2018 1:54 PM by Sarah Zaleski

    Table Calcs used to create a BackLog/Burndown Chart, counting values inside a measure fields

    Sarah  Zaleski

      I have used example after example with no avail.  searched for backlog and burndown charts but i still haven't got it right.  Asking for help.

      This is only a small amt of data so numbers won't match.  I am trying to use theses calcs to create the chart

      The data is filtered on C Name, C Modulename, C Type (Workitem) and Max Update.

      sheet1 - start Data1 is ifrst set of data i needed - it's good

      sheet2 - Data1 Max Updated status Marked - limits data to status of the max C updated field = it's good

      sheet3 - Data1 Max Updated Category Sum - trying to sum previous data sheet info - not right - i'm not doing the table calc right in order to count up each status in existence

      total Draft waitingProposal waitingPropReview waitingcode waitingCodeReview waitingUnitTest waitingUnitTestReview waitingSoftwareDescription waitingDescriptionReview waitingIntegration waitingVerification waitingValidation waitingReleased released

      Total requirements(number of records) 157 2 53 2 48 27 7 12 2 1 2 0 1 0 0

      SumTotReq = sum([Total Draft]) + sum([WaitingProposal])+ sum([WaitingProposalReview])+sum([WaitingCode])+sum([WaitingCodeReview])+sum([waitingUnitTest])+sum([waitingUnitTestReview])+sum([waitingSoftwareDescription])+sum([waitingDescriptionReview])+sum([waitingIntegration])+sum([waitingVerification])+sum([waitingValidation])+sum([waitingReleased])

       

      SumTotReq = 157 = 2 + 53 + 2 + 48 + 27 + 7 + 12 + 2 + 1 + 2 + 0 + 1 + 0 + 0

       

      trying to calculate current back log for each status.

       

      total Draft waitingProposal waitingPropReview waitingcode waitingCodeReview waitingUnitTest waitingUnitTestReview waitingSoftwareDescription waitingDescriptionReview waitingIntegration waitingVerification waitingValidation waitingReleased released

      Total requirements(number of records) 157 2 53 2 48 27 7 12 2 1 2 0 1 0 0

      sum of weighting factors                        66 11 10 9 8 7 6 5 4 3 2 1 0 0 0

      current back log 1260 =                         22 530 18 384 189 42 60 8 3 4 0 0 0 0

      starting backlog 1727 =                      (157*11)

       

      then display in bar chart Starting Back Log and current back log for each day not skipping missing days was going to use Show Missing on C Updated field to hopefully get that

      thanks in advance