In Azure DevOps, can I create a query that calculates project health based on PBI data?












1















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







share|improve this question



























    1















    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







    share|improve this question

























      1












      1








      1


      1






      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







      share|improve this question














      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






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 13 '18 at 17:31









      Mike HoferMike Hofer

      10.4k95591




      10.4k95591
























          1 Answer
          1






          active

          oldest

          votes


















          1














          You just answered your own question ;-)



          Yes, the only way to achieve this sort of accumulation is to write your own extension.






          share|improve this answer
























          • 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











          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
          });


          }
          });














          draft saved

          draft discarded


















          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









          1














          You just answered your own question ;-)



          Yes, the only way to achieve this sort of accumulation is to write your own extension.






          share|improve this answer
























          • 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
















          1














          You just answered your own question ;-)



          Yes, the only way to achieve this sort of accumulation is to write your own extension.






          share|improve this answer
























          • 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














          1












          1








          1







          You just answered your own question ;-)



          Yes, the only way to achieve this sort of accumulation is to write your own extension.






          share|improve this answer













          You just answered your own question ;-)



          Yes, the only way to achieve this sort of accumulation is to write your own extension.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          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



















          • 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


















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          -

          這個網誌中的熱門文章

          Xamarin.form Move up view when keyboard appear

          圖片
          .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I'm trying to build a Chat app UI, the idea of the Layout was pretty simple: When the input bar is focused, keyboard show up and "push" up the chat bar, as it's a grid, the ListView will resize to fit the screen: I update the input bar's margin to "push" it up: NSValue result = (NSValue)args.Notification.UserInfo.ObjectForKey(new NSString(UIKeyboard.FrameEndUserInfoKey)); CGSize keyboardSize = result.RectangleFValue.Size; if (Element != null){ Element.Margin = new Thickness(0, 0, 0,keyboardSize.Height); //push the entry up to keyboard height when keyboard is activated } And this is ...
          閱讀完整內容

          Post-Redirect-Get with Spring WebFlux and Thymeleaf

          圖片
          .everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 2 Can someone explain to me how to implement the post-redirect-get pattern in Spring WebFlux and Thymeleaf? What subscribes on the database save method? @GetMapping("/register") public String showRegisterForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping public String processRegisterForm(@Valid User user, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "register"; } else { userRepository.save(user); //what subscribes on this? //how to redirect on e.g. "/login"? ...
          閱讀完整內容

          Anylogic : not able to use stopDelay()

          圖片
          -2 I am building a railway station model. I want a train to depart when I click a button. I want to call stopDelay() for that but I am not sure how to do that and from which place. anylogic share | improve this question asked Nov 23 '18 at 10:12 Anupam Singh Anupam Singh 1 Hi Anupam, welcome to SOF. Please check how to ask good questions, see link below. Your question is...
          閱讀完整內容