How to add previous row to the next row

Hello,

Can you please share the actual query that calculates the number of passed tests?

Regards,
Victoria -

Hi this is my created SQL with the Total Passed and Total Executed TC's 

SELECT 
  Combined_Date,
    SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = 'Passed' THEN 1 ELSE 0 END) AS Total_Passed,
    SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = 'Passed' THEN 1 ELSE 0 END) + 
    SUM(CASE WHEN TC.EXECUTION_STATUS_NAME = 'Failed' THEN 1 ELSE 0 END) AS Total_Executed
FROM 
    SpiraTestEntities.R_TestRuns AS TR
INNER JOIN 
    SpiraTestEntities.R_TestCases AS TC 
    ON TR.END_DATE = TC.EXECUTION_DATE
WHERE 
    TR.PROJECT_ID = ${ProjectId}
GROUP BY 
    TruncateTime(TR.END_DATE) AS Combined_Date
 

Hi,

To add the value of the previous row to the current row (cumulative total), you can use the function to calculate the total running in order of execution date. As for creating an additional date column increasing by Planned_date every 5 days, you just need to repeat the operation of adding 5 days for each record.

Monkey Mart

You can use the function to determine the total running in order of execution date by adding the value of the previous row to the current row (cumulative total). 

Sprunki Incredibox