Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I would like to write an expression that only displays the count of records that appear more than once.
i.e :-
Table | |
Number | Count |
Anne | 1 |
Mark | 1 |
Anne | 1 |
John | 1 |
Peter | 1 |
Peter | 1 |
Peter | 1 |
Result
Distinct Number | sum(count)>1 |
Peter | 3 |
Anne | 2 |
The script I am currently using is = Count ({<Value = {"= Sum (Count) > 1"}>} Distinct Name) but does not give the correct result
I have also tried this script but still does not give the correct result
=Count( if( (aggr(Sum(count_names),name)) > 1, name ) )
You could try this on maybe:
dimension : if(count(Names)>1, Names)
measure : count(Names)
its's a measure and count(names) would count all the names that appear and not the ones that appear more than once