Tableau Top N set to 10 of group set is showing more than 10

147 Views Asked by At

How can I get top 10 results of my longest rides to date or filter the results to grab distinct string which would be the [Title] of the bike ride? Is there a custom formula I can enter?

My result is showing two results for Ride 1 and Ride 6 which are identical. Therefore I'm getting 12 results instead of 10. As the year goes on, I may repeat a ride and continue to run into this so I'm looking to find a solution that would cover any duplicate titled ride.

on my group set, by field, Top 10 Distance, AVG or MAX (shows the dupes for two rides) group set

On my Top N parameter I've tried: By field, Top 10 Distance Sum (this shows all rides which is more than 10)

I've done: By field, Top 10 Distance Max (this shows the dupes for two rides)

I've done: By field, Top 10 Distance Avg (this also shows the dupes for two rides)

packed bubbles

0

There are 0 best solutions below