Forum Discussion

jppuam's avatar
jppuam
Helper V
3 years ago

Azure DevOps Timelog

Hello,

i'm trying to read the hours that i've report on Azure, regarding Catalog Request that could have several User Stories, that could have several Tasks, like the example below:

 

CR         CR Name                  US       US Name       Task     Task Name

15843Catalog Request 115858User Story 128639Task 1
15843Catalog Request 115858User Story 128641Task 2
15843Catalog Request 115858User Story 128643Task 3
15843Catalog Request 115858User Story 128644Task 4
15843Catalog Request 115860User Story 247545Task 5
15843Catalog Request 115860User Story 247545Task 5
15843Catalog Request 115860User Story 247545Task 5
15843Catalog Request 115860User Story 250130Task 6
15843Catalog Request 115860User Story 250130Task 6
15843Catalog Request 115860User Story 250130Task 6
15843Catalog Request 115860User Story 250130Task 6

 

i'm trying to sum the hours from the timeline, but it repeats on the CR the hours from the US and from the Tasks. How can i do a sum correctly ?

 

thanks,

JR

 

 

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi jppuam ,

     

    What is the expected result?

     

    • jppuam's avatar
      jppuam
      Helper V
      3 years ago

      Hello CRT,

      sorry for the reponse delay.

      i give other example, that i think its more clear.

       

       

       

       

       

       

       

       

       

       

       

       

       

      How can i maker that calculation ? just a correction its not total hours of process son (the correct is the main process, but the IDs are correct)

      Thanks for the help,

      JR