
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Selecting the first instance of the id status
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 |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached example
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am not able to get the result for the above expression.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What are you getting and what are you looking to get when you use @Gysbert_Wassenaar expression and calculated dimension?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data is not getting displayed, it's completely empty straight table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It might be easier if you are able to share a sample to show what is going on?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
okay, sounds good

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
Did you get any chance to look into the above scenario ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where do I need to look? I didn't see any sample attached? Am I missing something?
