Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)
how to generate pseudo random numbers and row-count in Tableau?

1 Answer

0 votes
by (47.2k points)

Hi Vaibhav,

You can create random numbers using a function called RANDOM(). Even though the function is not shown within the functions in calculative field.

RANDOM() returns a decimal number from [0 - 1]. This function does not take any arguments/parameters.

To get a integer big number ,you can use one or more random function together and multiply with 10^4 or higher power.

For example.

Create random numbers using calculated field. ( I used 10^5 as multiplication number, you can choose even any number. To avoid duplicates i used 2 random() functions. )

After adding the field to the table .

Hope this helps you.

You can check Tableau Course online to learn more about tableau from basic to advance level.

Related questions

0 votes
1 answer
asked Jul 20, 2019 in Java by Anvi (10.2k points)
0 votes
1 answer
asked Feb 26, 2021 in Python by laddulakshana (16.4k points)
0 votes
1 answer
asked Jul 4, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories