Working with advanced operations
In this section, we will focus on advanced dataset operations. We will learn to add calculated fields to our dataset and apply dataset operations such as filtering and joining. Finally, we will add security controls, including row- and column-level filters. For this section, we will use our SPICE dataset that we configured earlier in this chapter.
Adding calculated fields
There are a number of prebuilt functions with QuickSight that we can use when building a calculated field. Those functions include the following: