In Azure DevOps, can I create a query that calculates project health based on PBI data?
Using the Scrum process template, I'd like to be able to create a query that I can use to display a pie chart on my overview page. This pie chart would essentially display a breakdown of PBIs in red/green/yellow status.
Criteria for each might be:
- Red: Blocked
- Yellow: Not blocked AND (X days elapsed since work began)
- Green: Not blocked, on time
Ideally, this information would roll up to the feature and epic levels (any feature that has a red or yellow PBI is red, respectively, and any epic that has a red or yellow feature is a red or yellow feature, respectively). But that's entirely optional at this point.
For the life of me, I can't figure out how to create a query to accomplish the base query. It might not be possible, and I can live with that.
Is the only solution to this problem to create an extension?
azure-devops reporting
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
add a comment |
Using the Scrum process template, I'd like to be able to create a query that I can use to display a pie chart on my overview page. This pie chart would essentially display a breakdown of PBIs in red/green/yellow status.
Criteria for each might be:
- Red: Blocked
- Yellow: Not blocked AND (X days elapsed since work began)
- Green: Not blocked, on time
Ideally, this information would roll up to the feature and epic levels (any feature that has a red or yellow PBI is red, respectively, and any epic that has a red or yellow feature is a red or yellow feature, respectively). But that's entirely optional at this point.
For the life of me, I can't figure out how to create a query to accomplish the base query. It might not be possible, and I can live with that.
Is the only solution to this problem to create an extension?
azure-devops reporting
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
add a comment |
Using the Scrum process template, I'd like to be able to create a query that I can use to display a pie chart on my overview page. This pie chart would essentially display a breakdown of PBIs in red/green/yellow status.
Criteria for each might be:
- Red: Blocked
- Yellow: Not blocked AND (X days elapsed since work began)
- Green: Not blocked, on time
Ideally, this information would roll up to the feature and epic levels (any feature that has a red or yellow PBI is red, respectively, and any epic that has a red or yellow feature is a red or yellow feature, respectively). But that's entirely optional at this point.
For the life of me, I can't figure out how to create a query to accomplish the base query. It might not be possible, and I can live with that.
Is the only solution to this problem to create an extension?
azure-devops reporting
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
Using the Scrum process template, I'd like to be able to create a query that I can use to display a pie chart on my overview page. This pie chart would essentially display a breakdown of PBIs in red/green/yellow status.
Criteria for each might be:
- Red: Blocked
- Yellow: Not blocked AND (X days elapsed since work began)
- Green: Not blocked, on time
Ideally, this information would roll up to the feature and epic levels (any feature that has a red or yellow PBI is red, respectively, and any epic that has a red or yellow feature is a red or yellow feature, respectively). But that's entirely optional at this point.
For the life of me, I can't figure out how to create a query to accomplish the base query. It might not be possible, and I can live with that.
Is the only solution to this problem to create an extension?
azure-devops reporting
azure-devops reporting
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
asked Nov 13 '18 at 17:31
Mike HoferMike Hofer
10.4k95591
10.4k95591
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You just answered your own question ;-)
Yes, the only way to achieve this sort of accumulation is to write your own extension.
answered Nov 14 '18 at 10:08
FlexFlex
20218
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
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%2f53286564%2fin-azure-devops-can-i-create-a-query-that-calculates-project-health-based-on-pb%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
You just answered your own question ;-)
Yes, the only way to achieve this sort of accumulation is to write your own extension.
answered Nov 14 '18 at 10:08
FlexFlex
20218
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
add a comment |
You just answered your own question ;-)
Yes, the only way to achieve this sort of accumulation is to write your own extension.
answered Nov 14 '18 at 10:08
FlexFlex
20218
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
add a comment |
You just answered your own question ;-)
Yes, the only way to achieve this sort of accumulation is to write your own extension.
answered Nov 14 '18 at 10:08
FlexFlex
20218
You just answered your own question ;-)
Yes, the only way to achieve this sort of accumulation is to write your own extension.
answered Nov 14 '18 at 10:08
FlexFlex
20218
answered Nov 14 '18 at 10:08
FlexFlex
20218
answered Nov 14 '18 at 10:08
FlexFlex
20218
answered Nov 14 '18 at 10:08
FlexFlex
20218
20218
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
add a comment |
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
It's not the answer I was hoping for, but I can deal with it. Thank you for your response.
– Mike Hofer
Nov 14 '18 at 12:25
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%2f53286564%2fin-azure-devops-can-i-create-a-query-that-calculates-project-health-based-on-pb%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
