Selecting the first instance of the id status

[kiranb13]

Hi,

I have the below following data.

Test ID	Run ID	Result
1	1	Passed
1	2	Passed
1	3	Failed
1	4	Blocked
1	5	NA
2	6	Failed
2	7	Passed
2	8	Passed
3	9	NA
3	10	Passed
3	11	Passed
4	12	Passed
4	13	Passed
5	14	Failed
5	15	Passes
5	16	NA

I need the count of the test passed and failed the column TestId for the 1st instance in RunId. Other than these two status i need to ignore that particular row.

Expected Result :

Count of Passed=	2
Count of failed=	2

[Gysbert_Wassenaar]

See attached example

[kiranb13]

Hi Gysbert,
I am not able to get the result for the above expression.

[sunny_talwar]

What are you getting and what are you looking to get when you use @Gysbert_Wassenaar expression and calculated dimension?

[kiranb13]

Data is not getting displayed, it's completely empty straight table.

[sunny_talwar]

It might be easier if you are able to share a sample to show what is going on?

[kiranb13]

Hi Sunny,

Above is requirement. 

FTR=(No of TC's passed/(No of TC's passed+No of TC's failed))

I need TC's status Passed or Failed count at 1st instance.

[sunny_talwar]

okay, sounds good

[kiranb13]

Hi Sunny,

Did you get any chance to look into the above scenario ?

[sunny_talwar]

Where do I need to look? I didn't see any sample attached? Am I missing something?