george1610
Programmer
- Mar 27, 2025
- 1
Hi all,
I have the dataset like:
SAMPLE_TYPE TESTS BOTTLES
--------------- ------- ----------
A T1 B1
A T2 B1
A T2 B1
B T1 B2
B T2 B3
How to group the above dataset into two different groups in CR?
TESTS fields need count of such test and BOTTLES field need distinct the value. Thanks.
SAMPLE_TYPE: A
TESTS COUNT
------ --------
T1 1
T2 2
BOTTLES
---------
B1
SAMPLE_TYPE: B
TESTS COUNT
------ --------
T1 1
T2 1
BOTTLES
---------
B2
B3
I have the dataset like:
SAMPLE_TYPE TESTS BOTTLES
--------------- ------- ----------
A T1 B1
A T2 B1
A T2 B1
B T1 B2
B T2 B3
How to group the above dataset into two different groups in CR?
TESTS fields need count of such test and BOTTLES field need distinct the value. Thanks.
SAMPLE_TYPE: A
TESTS COUNT
------ --------
T1 1
T2 2
BOTTLES
---------
B1
SAMPLE_TYPE: B
TESTS COUNT
------ --------
T1 1
T2 1
BOTTLES
---------
B2
B3