I created a program that counts points associated with people. Each person is associated with a location. I have no problem identifying the top N records (highest point count per location). This is shown in my attachment, on the first worksheet - "Awarded Points".
Now I want to play a game with the participants. In this case, imagine horse racing. (My program is educational. I call this Course Racing.) I want Tableau to select eight random people from one selected location. (I have a parameter filtering the locations. This is not in my example.) The names and some basic stats will be shown on a LED display linked to a Tableau view. I've simplified this on a worksheet called "Led Board".
On my example, there's a worksheet with a random number calculated field. Refreshing the data source will refresh the random number column. My first issue is applying a rank to the list. I can't get the Table Calculation to sort the list according to the random numbers. Lowest to highest or vice versa...doesn't matter. I just want 8 random people.
Assuming we can identify the users, my next issue will be figuring out how to do it on the Led Board.
I can do all this on the SQL side, outside of Tableau...via a stored procedure to pull eight members. But I'd like to identify a Tableau solution.