romeoek
Contributor
2022-01-18
07:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis Expression that displays the Count of Distinct names that appear more than once
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
Labels (5)
Labels
- Subscribe by Topic:
-
Application Development
-
Creating Analytics
-
Layout & Visualizations
-
Other
-
Scripting
608 Views
3 Replies
romeoek
Contributor
2022-01-18
07:57 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have also tried this script but still does not give the correct result
=Count( if( (aggr(Sum(count_names),name)) > 1, name ) )
588 Views
adrienL
Contributor
2022-01-18
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You could try this on maybe:
dimension : if(count(Names)>1, Names)
measure : count(Names)
542 Views
romeoek
Contributor
2022-01-19
02:17 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
its's a measure and count(names) would count all the names that appear and not the ones that appear more than once
509 Views