Scenarios

Scenarios allow you to shape numeric distributions based on other columns in your schema. For example, let's say your want to generate a file where each row represents the sale of a car including the model, region, sale price, and date of sale.

Here we use the normal distribution field type to generate reasonable prices. Let's look at some sample data:

See the problem? All models cost about the same on average. This isn't realistic. Let's create a scenario to better model the real world prices of each model.

Here we use the value of the model column to control the price range. We make the Focus model less expensive while boosting the price of the Explorer. We also adjust the standard deviation to simulate the wider price fluctuations seen on more expensive models.

Now let's change our schema to use our new scenario...

Let's have a look at some sample data...

Much better! Now our sales figures accurately represent the average price of each model.