Is TV static random

I have figured out a bit of a trick that might work for you (or some future reader).


1. create Calculated Field: [Random]



2. create Calculated Field: [Random Rank]



Put the [Random Rank] as the text data in marks:


So now instead of ranking 1234 along a SUM of something etc, it will rank() across whatever that first seed is for the initial random(). The seed never changes. You can change the view filter a bunch of different ways, but when you go back to any view filter it will return the same rows with the same random rank.


3. I combined this with a Parameter: "Select How Many" , Integer, 10, automatic, all


4.Create top/bottom # filter: [Selection Filter]

if [Random Rank]<= [Select How Many] then "Top N" elseif [Random Rank]>size()-[Select How Many] then "Bottom N" else "Others" END


Then you can show the [Selection Filter] and "Select How Many" parameter and users can pick how many random records they want and if they somehow don't like that mix of random, then they can just look at the "Bottom N" random ranked outputs.


Note: My original user request was "Please give us a random of X dimension, and random Y dimension, and random Z dimension" if you get this ask, note that any multiples of a normally distributed random variable is still a normally distributed random variable. It's not more or less random along any factor, and especially as you start to approach the Central Limit Theorem (>500 best, >350 decent) then you can basically consider those as normally distributed. So having one rank([Random]) set up should give you basically the same outcome probability results.

probability - Multiplication of a random variable with constant - Mathematics Stack Exchange

Sums of Independent Normal Random Variables | STAT 414 / 415

The importance of the normality assumption in large public health data sets. - PubMed - NCBI

1 of 1 people found this helpful