Skip to content

    • Beast Mode

    Beast Mode

    Random Number

    Coach
    in Beast Mode

    What is the best way to try and generate a random number in a Beast Mode? I am doing a presentation and want to remove names from my column and just make a beast mode to assign a random number. I tried doing rand() but that was not unique. I also tried doing length of name * rand() but that was also somehow not unique.

    **If this answer solved your problem be sure to like it and accept it as a solution!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      edited May 2024 Answer ✓

      @Ashleigh in that case, what if you did something with DENSE_RANK()?

      1. DENSE_RANK() over (order by SUM(value) desc)
      image.png

      You could then do something like this

      1. CONCAT('Customer ',DENSE_RANK() over (order by SUM(value) desc))
      image.png

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    Answers

    • Coach

      Are you wanting it to be non-repeating overall, or non-repeating where each name is the same random number?

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    • Coach

      @david_cunningham I am aggregating the values for each name so I need each name to have its own random number. Otherwise it tries to aggregate across multiple names.

      **If this answer solved your problem be sure to like it and accept it as a solution!

    • Coach
      edited May 2024 Answer ✓

      @Ashleigh in that case, what if you did something with DENSE_RANK()?

      1. DENSE_RANK() over (order by SUM(value) desc)
      image.png

      You could then do something like this

      1. CONCAT('Customer ',DENSE_RANK() over (order by SUM(value) desc))
      image.png

      David Cunningham

      ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
      ** Did this solve your problem? Accept it as a solution! ✔️**

    • Coach

      @david_cunningham that worked perfectly, thank you!!

      **If this answer solved your problem be sure to like it and accept it as a solution!

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories