Mixing
How do we display hours completed in current sprint in a query
I have a query that I am surprised has not been asked before (or maybe my search skills are not that great)
We are following Scrum and use Azure devops to track it, in that the lowest grain is a task, that has Original Estimate, Completed Work and Remaining Work
If for some reason a task is started in a sprint and is not finished, there are Some Completed Hours and some Remaining Hours left on the task.
We want to create a query that shows us no. of hours worked on a task in current (given) sprint
so for example -
End of Sprint 1
Task 1 -
Original Estimate = 20 hrs
Completed hours = 12 hours
Remaining hours = 8 hours
Task 2 -
Original Estimate = 10 hrs
Completed hours = 5 hours
Remaining hours = 8 hours
End of Sprint 2
Task 1 -
Original Estimate = 20 hrs
Completed hours = 20 hours
Remaining hours = 0 hours
Status - done
Task 2 -
Original Estimate = 10 hrs
Completed hours = 13 hours
Remaining hours = 3 hours
Status - In progress
Now I want to see, how much effort was made in Sprint 2 for each task-
Hence for
Task 1
8hrs - Planned
8hrs - completed
0 hrs - remaining
Task 2
8hrs - Planned
8hrs - completed
3 hrs - remaining
Hope it makes sense, please let me know if I could explain it any better.
Thanks.
.net tfs azure-devops agile sprint
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
add a comment |
I have a query that I am surprised has not been asked before (or maybe my search skills are not that great)
We are following Scrum and use Azure devops to track it, in that the lowest grain is a task, that has Original Estimate, Completed Work and Remaining Work
If for some reason a task is started in a sprint and is not finished, there are Some Completed Hours and some Remaining Hours left on the task.
We want to create a query that shows us no. of hours worked on a task in current (given) sprint
so for example -
End of Sprint 1
Task 1 -
Original Estimate = 20 hrs
Completed hours = 12 hours
Remaining hours = 8 hours
Task 2 -
Original Estimate = 10 hrs
Completed hours = 5 hours
Remaining hours = 8 hours
End of Sprint 2
Task 1 -
Original Estimate = 20 hrs
Completed hours = 20 hours
Remaining hours = 0 hours
Status - done
Task 2 -
Original Estimate = 10 hrs
Completed hours = 13 hours
Remaining hours = 3 hours
Status - In progress
Now I want to see, how much effort was made in Sprint 2 for each task-
Hence for
Task 1
8hrs - Planned
8hrs - completed
0 hrs - remaining
Task 2
8hrs - Planned
8hrs - completed
3 hrs - remaining
Hope it makes sense, please let me know if I could explain it any better.
Thanks.
.net tfs azure-devops agile sprint
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
add a comment |
I have a query that I am surprised has not been asked before (or maybe my search skills are not that great)
We are following Scrum and use Azure devops to track it, in that the lowest grain is a task, that has Original Estimate, Completed Work and Remaining Work
If for some reason a task is started in a sprint and is not finished, there are Some Completed Hours and some Remaining Hours left on the task.
We want to create a query that shows us no. of hours worked on a task in current (given) sprint
so for example -
End of Sprint 1
Task 1 -
Original Estimate = 20 hrs
Completed hours = 12 hours
Remaining hours = 8 hours
Task 2 -
Original Estimate = 10 hrs
Completed hours = 5 hours
Remaining hours = 8 hours
End of Sprint 2
Task 1 -
Original Estimate = 20 hrs
Completed hours = 20 hours
Remaining hours = 0 hours
Status - done
Task 2 -
Original Estimate = 10 hrs
Completed hours = 13 hours
Remaining hours = 3 hours
Status - In progress
Now I want to see, how much effort was made in Sprint 2 for each task-
Hence for
Task 1
8hrs - Planned
8hrs - completed
0 hrs - remaining
Task 2
8hrs - Planned
8hrs - completed
3 hrs - remaining
Hope it makes sense, please let me know if I could explain it any better.
Thanks.
.net tfs azure-devops agile sprint
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
I have a query that I am surprised has not been asked before (or maybe my search skills are not that great)
We are following Scrum and use Azure devops to track it, in that the lowest grain is a task, that has Original Estimate, Completed Work and Remaining Work
If for some reason a task is started in a sprint and is not finished, there are Some Completed Hours and some Remaining Hours left on the task.
We want to create a query that shows us no. of hours worked on a task in current (given) sprint
so for example -
End of Sprint 1
Task 1 -
Original Estimate = 20 hrs
Completed hours = 12 hours
Remaining hours = 8 hours
Task 2 -
Original Estimate = 10 hrs
Completed hours = 5 hours
Remaining hours = 8 hours
End of Sprint 2
Task 1 -
Original Estimate = 20 hrs
Completed hours = 20 hours
Remaining hours = 0 hours
Status - done
Task 2 -
Original Estimate = 10 hrs
Completed hours = 13 hours
Remaining hours = 3 hours
Status - In progress
Now I want to see, how much effort was made in Sprint 2 for each task-
Hence for
Task 1
8hrs - Planned
8hrs - completed
0 hrs - remaining
Task 2
8hrs - Planned
8hrs - completed
3 hrs - remaining
Hope it makes sense, please let me know if I could explain it any better.
Thanks.
.net tfs azure-devops agile sprint
.net tfs azure-devops agile sprint
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
asked Nov 21 '18 at 12:34
MudsMuds
3,11741629
3,11741629
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Can you please review the hours you have entered in the questions, I don't think they are right. Task 1 20 hr in Sprint 1 and 20 hour in sprint 2 then how come 8hrs - Planned ?
Also please give task a dummy name as Task 1 is in both sprint is subject to perception that both the tasks are same.
Moreover, irrespective, your question's answer is not query but the column options to view the list of items as per your preference.
answered Nov 29 '18 at 5:59
RkkRkk
4217
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53412148%2fhow-do-we-display-hours-completed-in-current-sprint-in-a-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Can you please review the hours you have entered in the questions, I don't think they are right. Task 1 20 hr in Sprint 1 and 20 hour in sprint 2 then how come 8hrs - Planned ?
Also please give task a dummy name as Task 1 is in both sprint is subject to perception that both the tasks are same.
Moreover, irrespective, your question's answer is not query but the column options to view the list of items as per your preference.
answered Nov 29 '18 at 5:59
RkkRkk
4217
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
add a comment |
Can you please review the hours you have entered in the questions, I don't think they are right. Task 1 20 hr in Sprint 1 and 20 hour in sprint 2 then how come 8hrs - Planned ?
Also please give task a dummy name as Task 1 is in both sprint is subject to perception that both the tasks are same.
Moreover, irrespective, your question's answer is not query but the column options to view the list of items as per your preference.
answered Nov 29 '18 at 5:59
RkkRkk
4217
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
add a comment |
Can you please review the hours you have entered in the questions, I don't think they are right. Task 1 20 hr in Sprint 1 and 20 hour in sprint 2 then how come 8hrs - Planned ?
Also please give task a dummy name as Task 1 is in both sprint is subject to perception that both the tasks are same.
Moreover, irrespective, your question's answer is not query but the column options to view the list of items as per your preference.
answered Nov 29 '18 at 5:59
RkkRkk
4217
Can you please review the hours you have entered in the questions, I don't think they are right. Task 1 20 hr in Sprint 1 and 20 hour in sprint 2 then how come 8hrs - Planned ?
Also please give task a dummy name as Task 1 is in both sprint is subject to perception that both the tasks are same.
Moreover, irrespective, your question's answer is not query but the column options to view the list of items as per your preference.
answered Nov 29 '18 at 5:59
RkkRkk
4217
edited Nov 29 '18 at 6:07
answered Nov 29 '18 at 5:59
RkkRkk
4217
answered Nov 29 '18 at 5:59
RkkRkk
4217
answered Nov 29 '18 at 5:59
RkkRkk
4217
4217
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
add a comment |
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Task 1 had 20 hrs work pending in beginning of S1, then we worked 12 hours on it, 8 remained for S2
– Muds
Dec 4 '18 at 10:10
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
Both tasks are Same infact, we could not finish task 1 in S1 thats why all this issue
– Muds
Dec 4 '18 at 10:11
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53412148%2fhow-do-we-display-hours-completed-in-current-sprint-in-a-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
