how to generate random numbers and row-count in Tableau

0 votes

how to generate pseudo random numbers and row-count in Tableau? 

Mar 13 in Tableau by Nithin
85 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

Hi,

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.

answered Mar 13 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,200 points
1,414 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,200 points
77 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,550 points
1,104 views
0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 830 points
46 views
0 votes
1 answer

Hide alternative rows in tableau

Hi Mike, Follow below steps: 1. Select required Dimensions/Measures. 2. ...READ MORE

answered Apr 22 in Tableau by CHERUKURI
• 13,940 points
13 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
946 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,200 points
36 views
0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 13,940 points
44 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22 in Tableau by CHERUKURI
• 13,940 points
22 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.