Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28639 | Task 1 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28641 | Task 2 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28643 | Task 3 |
| 15843 | Catalog Request 1 | 15858 | User Story 1 | 28644 | Task 4 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 47545 | Task 5 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 6 |
| 15843 | Catalog Request 1 | 15860 | User Story 2 | 50130 | Task 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
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
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 27 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 69 | |
| 56 | |
| 38 | |
| 21 | |
| 21 |