You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hi community i struggled a lot to try to find a root cause with no success. I try to count number of test failed , number of test succees for requirements.
I m using table transfomer to do some sl request on a table
I have the following request :SELECT T1.'Requirement',
Hi @renaud staessens,
Please use the auto complete hints given by the Table Transformer macro while typing the SQL query. The first thing that I saw were the 'T1.TestStatut' parts. It is not correct in general: T1.’TestStatus’ is a correct variant (the quotes shouldn’t include the T1. part and the column name should be identical to the one that you really have in your table).
Now please try the following SQL query for the case:
COUNT(DISTINCT 'Tests') AS 'Number of Tests',
COUNT(DISTINCT('Bugs')) AS 'Number of Bugs',
COUNT(DISTINCT 'Failed Tests') AS 'Number of Failed Tests'
CASE WHEN 'TestStatus' IS "FAIL"
AS 'Failed Tests'
GROUP BY 'Requirement'
Hope it helps your case.