Enriching your data
One of the exciting features of SPICE is the ability to transform data and also create additional derived fields. Let's look at this feature with an example; follow these steps to add a new derived field to the dataset we just created:
From the QuickSight home page, click on Manage data.
Select the usasalarybyzipandcity that was created in the previous Joining data in SPICE section and then click on Edit data set.
Select New Field and then follow the wizard on the right to create a new derived field.
In this example, we are going to use the
toUppperfunction in the formula and convert the statement name to uppercase.
Figure 3.10: Derived column
This completes the example on how to create a new derived field. Now let's review the various functions available in SPICE.
Arithmetic and comparison operators
For numeric data types, SPICE allows the following arithmetic and comparison operators in calculated fields:
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
Equal (=)
Not...
