AnsweredAssumed Answered

Calulate number of unique entries by a certain attribute?

Question asked by JingjingLiang on Jan 15, 2015
Latest reply on Jan 17, 2015 by philmodjunk

Title

Calulate number of unique entries by a certain attribute?

Post

Hi,

I am new to FM Pro and have little experience with the scripts. Can anyone show me how to obtain the number of unique entries in a dataset by a certain attributes?

For example, in the following table (with heading), how can I calculate the number of unique entries in B, by different A data (the answer is for A=1, there are 2 unique B entries; for A=2, there are 3 unique B entries; for A=3, there is 1 unique B entry)?

A                 B

1                  7

1                  8

1                  7

2                  6

2                  7

2                  8

3                  6

3                  6

Thanks.

-Jingjing

Outcomes