0

Random number generator

As in Excel It would be helpful to have a function which generates a random number between 0 and 1 eg. Rand() and one which generates a random number between two set values e.g. RandBetween(low, high).

2 comments

  • 0
    Avatar
    Executive Dashboard
    I agree this would also be helpful for the selection of random data. We currently have a requirement to implement a "Tip of the Day" to our dashboard. A spreadsheet was created with the quotes and is hooked up as our data source. However, we have no way to select a random record from it.
  • 0
    Avatar
    Kahlil Hodgson
    You could do the "Tip of the Day" randomization by creating an Excel spreadsheet with two columns: day and random. Fill the first column with a numbers 1 through 365, and populate the second using the built in Rand() function. Upload this as a datasource and use that to select a random number based on the current day number.
Please sign in to leave a comment.