This chapter covered the topic of calculations and the transformation of data. We focused on some advanced calculations using some of Spotfire's OVER methods and gave examples of adding rows to existing tables and pivoting and unpivoting data tables.
We covered the differences between calculated columns and custom expressions in visualizations—remember that calculated columns do not recalculate based on filtering!
Moving beyond basic visualization building, we explored Spotfire's built-in data-wrangling functions to create and manipulate tall and wide tables through pivot and unpivot operations.
Spotfire's versatile and comprehensive suite of data-modeling tools offers excellent flexibility. It can be used to support the data discovery needs of an individual Analyst; it can also support an enterprise business intelligence deployment on top of a data...
