unique selection
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys
I have this table
Name | Value | Address |
Andrew | 1 | Main Street 4 |
Paul | 2 | Cuba street 6 |
Andrew | 2 | St. Church street 2 |
Paul | 3 | Ford street 89 |
I'm using Unique tool to select only one name from column Name, but ho i can be sure that the row with the highest value is selected?
Solved! Go to Solution.
- Labels:
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AnGi
Just to add you can get the highest value as unique selection by sorting value on descending and then applying unique tool. Unique tool always takes first occurrence.
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05,
I know that a unique tool is sorting the data first which is why I didn't propose this solution.
That is why I am not the biggest fan of relying on the unique tool in situations like this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 Sample tool is also sorting the data:
and you cannot be sure that you will get the results that you expect as this sorting will be done only on the value that you have used for the grouping.
If the user wanted to have the max value of something for a certain column I don't think you can be 100% sure that you will get the correct values for a sample/unique tool.