<description/><language>en-US</language><copyright>(C) Copyright 2006-2024 Inflectra Corporation.</copyright><managingEditor>support@inflectra.com</managingEditor><category domain="http://www.dmoz.org">/Computers/Software/Project_Management/</category><category domain="http://www.dmoz.org">/Computers/Software/Quality_Assurance/</category><generator>KronoDesk</generator><a10:contributor><a10:email>support@inflectra.com</a10:email></a10:contributor><ttl>120</ttl><item><guid isPermaLink="false">KB802</guid><author>Sam I (sriram@inflectra.com)</author><title>Graphing the Lead Time and Cycle Time - Part 3 When the data for creation date, start date, and end date are good, we can aggregate the data in a graphical format. This article will demonstrate how to write a simple query to show the trends of these lagging metrics. Thu, 22 Feb 2024 04:05:36 -05002024-02-23T12:49:14-05:00/Support/KnowledgeBase/KB802.aspxKB801Sam I (sriram@inflectra.com)Cycle Time Lead TimeAddressing incorrect data before graphing Lead Time and Cycle Time - Part 2 When aggregating lead time and cycle time graphically, it is important to ensure correct data is present in the required date fields that mark the appropriate workflow status required for computing the lead time and cycle time metrics. This article explains how to perform some diagnostics before aggregating data in the graphs using the task module. Wed, 21 Feb 2024 20:54:05 -05002024-02-23T12:44:04-05:00/Support/KnowledgeBase/KB801.aspxKB800Sam I (sriram@inflectra.com)Lead Time Cycle Time AgileCreating the Report for computing the Lead Time and Cycle Time - Part 1 One of the frequent questions that the Agile Project teams face is computing the cycle and Lead time. Depending upon the teams practices, this computation may be applied for Requirements, Tasks, or Defects. This article addresses how to create a report for lead time and cycle time based on tasks. Wed, 14 Feb 2024 17:12:03 -05002024-02-23T12:43:49-05:00/Support/KnowledgeBase/KB800.aspxKB789Sam I (sriram@inflectra.com)Custom Report Test Set Test Case Test StepsCustom Report of Test Sets, Test Cases, and Test Steps One of our customers recently asked about creating a report that brought the test set, test case, and test step in a specific format to help them with their test planning. This KB article explains how this can be done. Tue, 19 Dec 2023 14:28:39 -05002024-03-21T12:22:51-04:00/Support/KnowledgeBase/KB789.aspxKB784Sam I (sriram@inflectra.com)Spira URLCreating a Link to the Spira Artifact Item in ESQL One of the customers recently asked about including a link as an additional column in the tabular report so that it is easy for the receiver to directly access the link instead of navigating through the system. This article provides the query to accomplish this request as part of their query. Mon, 23 Oct 2023 17:55:28 -04002023-10-24T16:34:03-04:00/Support/KnowledgeBase/KB784.aspxKB783Sam I (sriram@inflectra.com)EVM SV SPI CV CPI ETC EAC TCPIEVM - Leading Indicators for Forecasting In a series of EVM articles, part 1 , part 2 , and part 3 , we discussed about implementing the earned value management (EVM) lagging indicators. In this article, we will discuss the forecasting metrics. Fri, 20 Oct 2023 14:54:20 -04002023-10-20T19:41:27-04:00/Support/KnowledgeBase/KB783.aspxKB782Sam I (sriram@inflectra.com)EVMImplementing EVM - Schedule and Summary of Task Based Cost Metrics in Spira - Part 3 This is the final extension to the Earned Value Management. The main difference here is that the the task module contains the details of the costs that needs to be aggregated and added to the cost of time at the blended rate. Tue, 17 Oct 2023 16:18:46 -04002023-10-20T14:36:38-04:00/Support/KnowledgeBase/KB782.aspxKB781Sam I (sriram@inflectra.com)Implementing EVM - Schedule and Cost Metrics in Spira - Part 2 This is an extension of the earlier EVM article on implementing schedule metrics alone. In this article, let us explore adding cost metrics, such as the cost variance and the cost performance index, with summarized costs tracked at the release level. Wed, 11 Oct 2023 17:01:02 -04002023-10-17T18:05:35-04:00/Support/KnowledgeBase/KB781.aspxKB779Sam I (sriram@inflectra.com)Implementing EVM - Schedule Metrics in Spira Recently, an attendee in a conference asked me how Spira can support the earned value management (EVM) for project tracking. The question came up as cost is not part of the standard Spira setup. This article addresses this need. Mon, 25 Sep 2023 17:02:12 -04002023-10-17T18:04:41-04:00/Support/KnowledgeBase/KB779.aspxKB773Sam I (sriram@inflectra.com)Requirement StatusAccommodating New Requirement Statuses Spira currently limits the statuses available for the requirement artifact due to the support the requirement status level automation. One request, despite infrequent, is to address how to accommodate excluding requirements at a release level or reporting on requirements in this required but currently unavailable requirement status. This article addresses this requirement. Sun, 23 Jul 2023 00:32:02 -04002023-07-23T08:54:17-04:00/Support/KnowledgeBase/KB773.aspxKB769Sam I (sriram@inflectra.com)Risk Cross-Project Risk Program Risk Portfolio RiskCreating a Risk Register at Portfolio Level A customer recently asked how to get a list of all risks across all projects within a portfolio. This article explains how to create such a report. Thu, 29 Jun 2023 15:31:48 -04002023-06-29T15:34:04-04:00/Support/KnowledgeBase/KB769.aspxKB757Sam I (sriram@inflectra.com)Release Phase Sprint V-Model Spira ClonePurpose behind a Release Clone Option We had a customer ask recently why this clone option at the release level in Spira did not make a copy of all the artifacts associated in the previous release. This article addresses this question. Wed, 24 May 2023 12:27:35 -04002023-05-24T19:06:16-04:00/Support/KnowledgeBase/KB757.aspxKB754Sam I (sriram@inflectra.com)Bulk EditImpact of Bulk Edit Privilege in Spira A customer recently asked about the impact of turning off the Bulk Edit privilege in Spira. This blog addresses the specific areas this Bulk Edit privilege influences. Thu, 18 May 2023 16:09:56 -04002023-05-18T20:00:37-04:00/Support/KnowledgeBase/KB754.aspxKB710Sam I (sriram@inflectra.com)Formatting Dates in Custom Report in ESQL A customer recently asked how to format the date format removing the time component in the custom report. This article address how it can be done. Tue, 06 Dec 2022 22:32:02 -05002024-02-14T17:23:31-05:00/Support/KnowledgeBase/KB710.aspxKB668Sam I (sriram@inflectra.com)Custom Reporting Entity SQL Electronic SignatureCreating a Velocity Comparison Chart for Agile or Scrum Product Delivery A customer once asked how to create a velocity comparison chart for their Scrum Team to measure planned versus actual velocity across the releases. This article addresses how this chart can be created. Wed, 31 Aug 2022 00:26:48 -04002022-11-04T19:26:39-04:00/Support/KnowledgeBase/KB668.aspxKB667Sam I (sriram@inflectra.com)Custom Report Custom List Graph Custom Query SQLCreating a Custom Graph based on a set of values in a Custom List A customer recently asked about creating a custom graph based on a set of values in a custom list on an artifact. This article explains how this can be done. Wed, 31 Aug 2022 00:18:51 -04002022-09-23T21:20:31-04:00/Support/KnowledgeBase/KB667.aspxKB666Sam I (sriram@inflectra.com)Custom Report Sorting Filtering XSLT Task FoldersImplementing Sorting and Filtering on Tasks using XSLT In one of the training sessions on reporting, a request came up on how data in the XSLT can be sorted similar to ordering results using the ORDER BY clause in ESQL. Both ESQL and XSLT offer its own power which is beyond the scope of this article. But, this article explains a simple way to sort the folders and the tasks in these folders by filtering out the tasks in the root folder and filtering tasks that do not have a name filled in. Wed, 31 Aug 2022 00:18:34 -04002022-09-10T13:25:45-04:00/Support/KnowledgeBase/KB666.aspxKB665Sam I (sriram@inflectra.com)Custom Report Custom Property Data CheckCustom Report to pull Custom Properties with Data A customer had a list of custom properties on the requirement artifact. Some of these custom properties on some requirement had data filled in. When they pulled a report of these requirements, some of these empty custom properties took up much of the report space. So, the customer wondered about reporting only those non-empty custom properties on the artifact. This article explains how this can be achieved. Wed, 31 Aug 2022 00:18:20 -04002022-09-02T01:39:34-04:00/Support/KnowledgeBase/KB665.aspxKB664Sam I (sriram@inflectra.com)Custom Report Entity SQL Electronic SignatureCreating a Custom Report of Electronic Signature Approval on Test Cases A customer once asked how to create a list of all test cases that have electronic signature approval recorded. For example, let us say that you have electronic signature turned on for a specific transition operation in the Test Case. Then, how do we create a list of all the test cases that have electronic signature recorded? Wed, 31 Aug 2022 00:18:15 -04002022-08-31T10:47:06-04:00/Support/KnowledgeBase/KB664.aspxKB241David J (support1@inflectra.com)rapise training certificationiRP-100: Rapise Fundamentals Certification This article enumerates the different skills you need to be self-certified at the training course: Rapise iRP-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out. Thu, 02 Mar 2017 03:37:06 -05002017-03-02T03:38:54-05:00/Support/KnowledgeBase/KB241.aspxKB240David J (support1@inflectra.com)kronodesk training certificationiKD-100: KronoDesk Fundamentals Certification This article enumerates the different skills you need to be self-certified at the training course: KronoDesk iKD-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out. Wed, 22 Feb 2017 23:19:01 -05002017-02-23T01:51:51-05:00/Support/KnowledgeBase/KB240.aspxKB237David J (support1@inflectra.com)training certification spiraiSP-100: Spira Fundamentals CertificationThis article enumerates the different skills you need to be self-certified at the training course: Spira iSP-100 fundamentals. The article includes the list of skills in a readable format as well as a downloadable spreadsheet that you can fill out. Wed, 15 Feb 2017 05:00:00 -05002017-02-15T21:13:37-05:00/Support/KnowledgeBase/KB237.aspxKB236David J (support1@inflectra.com)training certificationsInflectra Training Certifications This article contains a sample spreadsheet that describes each of the course modules for being trained on our products: SpiraTeam Rapise KronoDesk Please download the spreadsheet and use to help self-certify your skills and competency with our products. Mon, 13 Feb 2017 05:00:00 -05002017-02-15T20:51:08-05:00/Support/KnowledgeBase/KB236.aspx