Unique Random numbers

Korpelak

Hello everyone!

I am trying to create random numbers for a table I have so that I can plot the records in quadrants depending of its area (department) and Importance (H, M, L).

Basically the idea is to plot each record (audit) in its quadrant and in its level, being very high importance closer to the center. Almost like a radar type of chart but with bubbles instead of lines.

How can I create random numbers (coordinates for plotting) and unique (for creating a jitter effect) taking in consideration the ranges? 

I have attached a sample file. And please share if you can think of a better way to achieve the same goal, I am not married to this approach.

Cheers,

Karina

sample.xlsx

danrh

I'm not positive on the specifics of your use case, but here's one way to generate random unique numbers:

I'm using RecordID to generate the unique numbers (depending on requirements for your range/increments you might need to tweak this), then I add a RAND() field to generate a sort order for those unique numbers, then Join on position.  This effectively adds a random unique integer to every record in the dataset.  Take a look, see if it fits the bill.

solution.yxmd