Add More Flavor to Your Data with New Recipe Ingredients
Bucket Date Fields
In a lens or dashboard, you can group the data by regular periods, such as quarter and month. But what if you wanted to view data by some other period, like season or trimester? That’s where date bucketing comes in.
Let’s say your company wants to analyze support cases by season. Now you can open up your cases dataset in a recipe and add a bucket field to show the season in which each case was opened.
To bucket a date field, click the field column header, and then click the Add Bucket () button to open the bucket field dialog. The default mode is Absolute, which lets you specify a date range and name for each bucket. In this example, each bucket is a season.
When you’re done, the new field appears alongside the date field you’re bucketing.
In Relative mode, each bucket is a period of time relative to the date that the recipe runs. You can create bucket periods based on days, weeks, months, quarters, or even years. For example, create a bucket field from the case created date to categorize cases by when they were opened. This takes a lot of work in the dataflow, but not in a recipe!
When you create a relative date bucket field, enter the start and end of each period, or use the sliders.
Again, when you’re done, the new field appears alongside the date field you’re bucketing.
Find a Perfect Match with Composite Key Augments
When you add data in a recipe, you can now match rows using up to five pairs of lookup keys. For example, imagine you are adding contact information to lead data in a recipe. Using names alone to match can result in duplicate matches when leads have the same name. Now, you can match on name and company to ensure you’re matching the right data.
To use composite keys, click the Add Data button () and select the lookup dataset. Wave still suggests the first pair of keys if it can, but now you also have the + Add Another option. Click this to select additional keys.
New Transformations and Changes
The Truncate transformation, which lets you create a field by taking characters from another field, is now called Substring to better reflect what it does. We also added the Extract Date Component and Convert Dimension to Measure transformations. To use these transformations, click the column header of the field you want to transform, and then click the Transform Suggestions () button.
Extract Date Component creates a field using a date or time component from a date field in the recipe.
For example, you can extract the hour component from the case created date to analyze case creation by hour of the day.
The Convert Dimension to Measure transformation takes numerical data in a dimension field to create a measure field.
Convert numerical data so that it can be used in calculations in recipes, dataflows, lenses, and dashboards. For example, you extracted the hour from the case created date to analyze metrics such as the average or earliest times of day cases are opened. But the extracted hour is sitting in a dimension field! Use the Convert Dimension to Measure transformation to free it up for statistical analysis in lenses and dashboards.
Change Field API Names and Labels
You can now edit the API name and label of new fields you create in a recipe, and the labels of existing fields. When you create fields, for example, when using bucketing or transformations, Wave creates the field name for you from the source field and the action. But CreatedDate_grain_Hour_dimensionToMeasure“CloseDate_delimitedSplit_1 is not all that helpful. You can edit these generated names to make them more meaningful to the people exploring the dataset.
To change a field name or label, click the field’s column heading, and then click the Navigate Fields () button. In the field navigator, click the Attributes tab to change the API name and field label.