Chart Expression

[JuanMu]

Hi All,
Is there any chart expression to calculate how many register are repeated more than twice?. For instance:

Values
1
1
1
3
3
3
3
4
5

The solution must be 2, the number 1 and number 3 are repeated more than twice.

Best regards,

Juan Muñoz.

[jwjackso · Accepted solution]

With data:

Data:
Load * Inline [
Values
1
1
1
3
3
3
3
4
5
];

The expression, Sum(If(Aggr(count(Values),Values) > 2,1,0)) returns 2.

[JuanMu]

Great!!!!!

Thanks a lot!!!!