Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

random sampling

[ Spoiler ] How to take number of rows as input and show random set of rows ?  
Anonymous's avatar
Anonymous
Not applicable
6 years ago

how to take row count from users?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create one table generateseries(1,1000)

 

then add it in slicer

 

Allow user to select number of samples

 

 

and undate it in above formula .

in var section add selectedvalue(table[series]) instead of 10.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks for the reply , but not working unfortunately. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      sorry my bad.

       

      You can take user input here.

       

      Because columns/tables are can not be dynamic.

      They will get loaded at first load only.

       

      So the formula will work for static values only not for dynamic values.

       

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.