O'Reilly logo

TIBCO Spotfire – A Comprehensive Primer by Michael Phillips

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Slicing and dicing data using hierarchy nodes

Spotfire provides a set of OVER functions to allow you to aggregate data over the nodes of a hierarchy, usually a date hierarchy but not necessarily. At its simplest level, the OVER function is a means to define at what granularity you wish to aggregate a value. For example, you could create the following calculated column in the baseball data:

Avg([Hits]) OVER [Team]

The result would be the average number of hits achieved by the players in each team. As each team has more than one row in the data, the lowest granularity of which is a player, you will end up with the following result:

Slicing and dicing data using hierarchy nodes

The OVER function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required