A customer recently mentioned that they have a specific report for seeing the failed test runs initiated from the test sets along with a count of the defects at the failed test step and the list of the defects. This article addresses how this can be accomplished. Fri, 27 Mar 2026 19:49:50 -04002026-03-30T21:16:06-04:00/Support/KnowledgeBase/KB948.aspxKB929Sam I (sriram@inflectra.com) A customer recently asked about their need to compute the days elapsed between two dates by suppressing the weekends and holidays. This article addresses how this can be done. Mon, 08 Dec 2025 19:59:01 -05002025-12-09T02:10:24-05:00/Support/KnowledgeBase/KB929.aspxKB926Sam I (sriram@inflectra.com) A customer recently asked if there is a way to see what incidents are associated with a testcase and also see what test cases were associated with an incident in a report format. This information is easily visible directly in the application, since the requirements, test case, test set and test run pages all have tabs where you can see the associated incidents/defects. However sometimes you may want this in a report format to share with stakeholders. This article explains the steps to create a custom report for this bidirectional traceability. Fri, 05 Dec 2025 22:28:24 -05002025-12-07T15:41:58-05:00/Support/KnowledgeBase/KB926.aspxKB920Sam I (sriram@inflectra.com) In some defense and allied sectors, the audit requirements may require traceability among the requirements themselves. Although Spria provides a traceability report between requirements and test cases, there may be a need to see any requirements immediate parent and immediate children! This article addresses how it can be done. Mon, 17 Nov 2025 17:43:11 -05002025-11-19T22:36:18-05:00/Support/KnowledgeBase/KB920.aspxKB918Sam I (sriram@inflectra.com) Spria already provides a traceability report between requirements and test cases. When the requirements are viewed in the document view, there is also an outline option that can be added which dynamically creates an outline. But, that option may not have the traceability to requirements available through the requirements-testcase traceability report. This article addresses how a custom report can be created to create this hierarchy, the parent requirement referenced by the requirement, and the test cases associated with them. Mon, 10 Nov 2025 23:37:43 -05002025-11-12T14:55:11-05:00/Support/KnowledgeBase/KB918.aspxKB913Sam I (sriram@inflectra.com) Spira provides a standard report, Printable Test Scripts that is used for recording results offline when the access to Spira may not be present. Users record the results on a paper and then update the system with their findings later. Sometimes, teams may have one or two additional properties at the test step level. The current standard report does not bring the test step level custom properties. This article discusses how to modify the existing report as a new custom report with the addition of test step level custom properties. Wed, 08 Oct 2025 18:03:05 -04002025-10-08T18:03:28-04:00/Support/KnowledgeBase/KB913.aspxKB912Sam I (sriram@inflectra.com)Turnaround TimeCycle TimeResponse TimeLead Time As part of defect triaging for effective decision-making, one may want to graphically reporting the Turnaround time by the severity of the incidents logged. This article addresses this need. Fri, 03 Oct 2025 22:18:01 -04002025-10-03T23:46:32-04:00/Support/KnowledgeBase/KB912.aspxKB911Sam I (sriram@inflectra.com)Response TimeTurn Around TimeCycle TimeLead Time A customer recently asked about reporting on the response time and turn-around-time, commonly known as TAT, on incidents logged. This article addresses this need. Wed, 01 Oct 2025 20:22:02 -04002025-10-01T20:22:02-04:00/Support/KnowledgeBase/KB911.aspxKB910Sam I (sriram@inflectra.com) A customer recently asked how they can report on the test cases newly created on the user stories on or after the sprint has started. This articles helps with creating such a custom report. Mon, 29 Sep 2025 17:13:18 -04002025-09-29T19:14:02-04:00/Support/KnowledgeBase/KB910.aspxKB900Sam I (sriram@inflectra.com)SpiraTestSpiraTeamSpiraPlanEntityRelationshipER ModelDatabase Model Frequently, customers ask for the database model, also called as the entity-relationship (ER) model that shows the relationship between the various entities. While these details can be gathered from the tables exposed, this article shows a minimalistic database model. Wed, 09 Jul 2025 20:07:09 -04002025-07-09T20:35:35-04:00/Support/KnowledgeBase/KB900.aspxKB891Sam I (sriram@inflectra.com)Test Set Test Case Test Case Owners within Test Set A customer in a training session recently asked if there is a way to get a count of the test cases by test case owners with in a test set. This KB article answers this request. Thu, 20 Feb 2025 19:08:17 -05002025-02-20T19:08:17-05:00/Support/KnowledgeBase/KB891.aspxKB890Sam I (sriram@inflectra.com)User Activity Report A customer recently requested help to create custom report to display all user ids, status of user ids(active/inactive), last time they login to the system and days they are not using their user ids. This KB article will help in addressing this request. Mon, 03 Feb 2025 20:42:47 -05002025-02-03T21:03:33-05:00/Support/KnowledgeBase/KB890.aspxKB889Sam I (sriram@inflectra.com)Test Sets Test Cases Custom Graph Test Case Count A customer in a webinar recently questioned how to get a count of the test cases in a test set that is not marked as completed. This KB article answers this request. Mon, 03 Feb 2025 16:34:15 -05002025-02-20T18:52:02-05:00/Support/KnowledgeBase/KB889.aspxKB874Sam I (sriram@inflectra.com)Quality Metrics Regression Test Efficiency The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the regression test efficiency. Thu, 15 Aug 2024 20:02:35 -04002024-08-15T20:02:41-04:00/Support/KnowledgeBase/KB874.aspxKB873Sam I (sriram@inflectra.com)Quality Metrics Defect Resolution Time Defect Cycle TIme The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the defect resolution time metric. Thu, 15 Aug 2024 19:51:23 -04002024-08-15T19:51:39-04:00/Support/KnowledgeBase/KB873.aspxKB872Sam I (sriram@inflectra.com)Quality Metrics Software Stability The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the software stability metric. Thu, 15 Aug 2024 19:36:57 -04002024-08-15T19:37:06-04:00/Support/KnowledgeBase/KB872.aspxKB871Sam I (sriram@inflectra.com)Quality Metric Test Case Cycle Time The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the test cycle time metrics for test cases. Thu, 15 Aug 2024 18:40:31 -04002024-08-15T18:41:24-04:00/Support/KnowledgeBase/KB871.aspxKB870Sam I (sriram@inflectra.com)Quality Metrics Defect Detection Rate The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the defect detection rate. Thu, 15 Aug 2024 18:21:36 -04002024-08-15T18:22:24-04:00/Support/KnowledgeBase/KB870.aspxKB869Sam I (sriram@inflectra.com)Quality Metrics Test Case Coverage The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the test case coverage metric. Thu, 15 Aug 2024 18:13:54 -04002024-08-15T18:14:02-04:00/Support/KnowledgeBase/KB869.aspxKB868Sam I (sriram@inflectra.com)Quality Metrics Test Case Reusability The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the summary of test case reusability. Thu, 15 Aug 2024 18:01:20 -04002024-08-15T18:04:52-04:00/Support/KnowledgeBase/KB868.aspxKB849Sam I (sriram@inflectra.com)Quality Metrics Automated Test Cases The Cost of Quality (CoQ) is about both product quality and process quality. As part of these considerations, quality assurance can focus on additional patterns. In this article, we will discuss how to graphically show the summary information on these metrics. Wed, 03 Jul 2024 18:53:38 -04002024-08-15T18:04:15-04:00/Support/KnowledgeBase/KB849.aspxKB846Sam I (sriram@inflectra.com)Risk Management FMEA Primary Risk Secondary Risk SpiraPlan SpiraTeam Organizations sometimes maintain a risk register and map risks from the risk register to individual projects. Each project may apply different risk rating scale, such as one project using FMEA and another using the standard Probability/Impact Assessment. This article addresses how this can be done. Wed, 26 Jun 2024 18:27:09 -04002024-06-26T18:27:57-04:00/Support/KnowledgeBase/KB846.aspxKB842Sam I (sriram@inflectra.com)Partner mVerve Monthly Processing Times Report Graph Customers frequently want to review the monthly processing times of requirements across various requirement types in specific Work-in-Progress (WIP) stages like Developed and Tested, categorizing them into four timelines: under 30 days, under 60 days, under 90 days, and above 90 days. This article addresses this request. Mon, 20 May 2024 17:00:25 -04002024-06-27T13:18:43-04:00/Support/KnowledgeBase/KB842.aspxKB841Sam I (sriram@inflectra.com)Partner mVerve Parent-Child Relationship View Report The Spira User Interface allows the indenting of requirements to accommodate the hierarchical thought process people envision in structuring the requirements. When these requirements are documented in a report format, the indentation visible in the user interface is missed. Some customers would prefer to see this indentation replicated in the report. This article addresses this requirement. Mon, 20 May 2024 16:41:08 -04002024-05-20T19:06:41-04:00/Support/KnowledgeBase/KB841.aspxKB840Sam I (sriram@inflectra.com)Partner mVerve Trend Reporting Often, the project stakeholders want to assess the effectiveness of the teams development processes to prioritize tasks and allocate resources more efficiently. This request requires a time series analysis of time taken to get things addressed in the development state. Such a request looks at breaking the time taken (t) into various cohorts, such as under 30 days (t 90). This article addresses these requests. Mon, 20 May 2024 16:24:14 -04002024-05-20T19:06:31-04:00/Support/KnowledgeBase/KB840.aspxKB839Sam I (sriram@inflectra.com)Task Analysis Task Priority Not all tasks are created equal in a project! Some activities may not contribute to the MVP and will be a nice to have rather than must to have. Therefore, the analysis of tasks within a project may also look at the priority types of the tasks. This article addresses this need. Fri, 17 May 2024 18:59:06 -04002024-05-20T19:08:43-04:00/Support/KnowledgeBase/KB839.aspxKB838Sam I (sriram@inflectra.com)Task Analysis Task Type Not all tasks are created equal in a project! Some activities may not contribute to the MVP and will be a nice to have rather than must to have. Therefore, the analysis of tasks within a project may also look at ideas based on the type of tasks. This article addresses this need. Fri, 17 May 2024 18:08:37 -04002024-05-20T19:08:39-04:00/Support/KnowledgeBase/KB838.aspxKB837Sam I (sriram@inflectra.com)Task Overdue Analysis Tasks Pareto Requirements Releases Sometimes, the analysis of tasks may be associated with both known and unknown releases. Simultaneously, analysis may also involve tasks either associated to requirements within a known release or just stand alone without connection to a release. Furthermore, this analysis may be limited only to the tasks in progress or not started at all. This article addresses how to accomplish this request. Fri, 17 May 2024 17:04:43 -04002024-05-20T19:08:10-04:00/Support/KnowledgeBase/KB837.aspxKB836Sam I (sriram@inflectra.com)Task Overdue Analysis Tasks Pareto Analyzing tasks is not limited to project releases. Sometimes, tasks may be unassigned to a release further impacting how certain project releases cant even start. So, applying Pareto level (80/20 rule) thoughts can be extended to dig deeper into the tasks. This article helps with this approach. Fri, 17 May 2024 13:56:15 -04002024-05-20T19:08:06-04:00/Support/KnowledgeBase/KB836.aspxKB835Sam I (sriram@inflectra.com)Task Overdue Analysis Late Start Late Finish EVM Schedule Variance Schedule Performance Index One of the frequent activities that is monitored in a plan-driven project is the schedule delays due to tasks. This article helps visualizing the tasks across the iterations to evaluate any task delay patterns that can be addressed. Thu, 16 May 2024 21:11:54 -04002024-05-21T12:58:55-04:00/Support/KnowledgeBase/KB835.aspxKB832Sam I (sriram@inflectra.com)Risk Burndown Risk LifeCycle Risk Management As part of ongoing monitoring of risks, one of the the charts that people monitor is called a risk burn down chart. This article helps with creating a risk burn down chart. Thu, 02 May 2024 17:14:23 -04002024-05-16T20:47:33-04:00/Support/KnowledgeBase/KB832.aspxKB819Sam I (sriram@inflectra.com)Test Case Estimated Hours Test Case Actual Hours Test Case Hours by Owner One of the customer asked if it is possible to create a bar chart of the estimated duration and the actual duration of a test case against the owner. This article addresses the requirement. Fri, 29 Mar 2024 18:45:20 -04002024-04-01T01:07:50-04:00/Support/KnowledgeBase/KB819.aspxKB817Sam I (sriram@inflectra.com) As part of the risk management lifecycle, frequently people look at risks in the identified, analyzed, evaluated, open, closed and rejected. While this is still a very good way to look at the risk management lifecycle, are there other things to monitor. This article reviews that thought process in depth. Fri, 29 Mar 2024 18:02:21 -04002024-04-09T15:17:48-04:00/Support/KnowledgeBase/KB817.aspxKB816Sam I (sriram@inflectra.com) As part of the Risk Management Life Cycle, the Risk Evaluation stage reviews unresolved risks for subsequent analysis. There are many types of risk evaluation that can be done but some of the common ones are evaluating by probability and impact assessment done on the risks. This KB article discusses the approach to evaluate the unresolved risks. Mon, 25 Mar 2024 18:15:47 -04002024-04-02T17:56:47-04:00/Support/KnowledgeBase/KB816.aspxKB815Sam I (sriram@inflectra.com)Risk Analysis Risk Management Life Cycle SpiraPlan The second stage of risk management lifecycle involves analyzing the risks identified. This involves expert judgement or first level subjective analysis to evaluate which risks are worth spending more time on. This article addresses how to report on such an analysis done. Mon, 25 Mar 2024 17:31:40 -04002024-04-02T17:56:16-04:00/Support/KnowledgeBase/KB815.aspxKB814Sam I (sriram@inflectra.com)Risk KPI Risk Identification Risk Breakdown Structure One of the frequent questions that the product or project teams face is knowing the number of risks across the risk breakdown structure. This risks identified metric not only helps with the teams ability to ensure their commitments are met but also increase the confidence that the product or project team is managing the project effectively. This article addresses how to report this metric. Mon, 25 Mar 2024 15:56:17 -04002024-04-02T17:55:50-04:00/Support/KnowledgeBase/KB814.aspxKB802Sam I (sriram@inflectra.com) 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 Time 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 Agile 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 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)SpiraURL 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 -04002025-06-11T14:28:11-04:00/Support/KnowledgeBase/KB784.aspxKB783Sam I (sriram@inflectra.com)EVM SV SPI CV CPI ETC EAC TCPI 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)EVM 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) 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) 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 Status 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 Risk 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 Clone 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 Edit 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) 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 Signature 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 SQL 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 Folders 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 Check 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 Reports Entity SQL Electronic Signature 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 -04002024-06-19T06:08:24-04:00/Support/KnowledgeBase/KB664.aspxKB241David J (adam.sandman+support@inflectra.com)rapise training 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 (adam.sandman+support@inflectra.com)kronodesk training 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 (adam.sandman+support@inflectra.com)training certification spiraThis 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 (adam.sandman+support@inflectra.com)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