Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying TIBCO Spotfire: A Comprehensive Primer
  • Table Of Contents Toc
  • Feedback & Rating feedback
TIBCO Spotfire: A Comprehensive Primer

TIBCO Spotfire: A Comprehensive Primer

By : Berridge, Phillips
3.6 (8)
close
close
TIBCO Spotfire: A Comprehensive Primer

TIBCO Spotfire: A Comprehensive Primer

3.6 (8)
By: Berridge, Phillips

Overview of this book

The need for agile business intelligence (BI) is growing daily, and TIBCO Spotfire® combines self-service features with essential enterprise governance and scaling capabilities to provide best-practice analytics solutions. Spotfire is easy and intuitive to use and is a rewarding environment for all BI users and analytics developers. Starting with data and visualization concepts, this book takes you on a journey through increasingly advanced topics to help you work toward becoming a professional analytics solution provider. Examples of analyzing real-world data are used to illustrate how to work with Spotfire. Once you've covered the AI-driven recommendations engine, you'll move on to understanding Spotfire's rich suite of visualizations and when, why and how you should use each of them. In later chapters, you'll work with location analytics, advanced analytics using TIBCO Enterprise Runtime for R®, how to decide whether to use in-database or in-memory analytics, and how to work with streaming (live) data in Spotfire. You'll also explore key product integrations that significantly enhance Spotfire's capabilities.This book will enable you to exploit the advantages of the Spotfire serve topology and learn how to make practical use of scheduling and routing rules. By the end of this book, you will have learned how to build and use powerful analytics dashboards and applications, perform spatial analytics, and be able to administer your Spotfire environment efficiently
Table of Contents (18 chapters)
close
close
Free Chapter
1
Section 1: Introducing Spotfire
6
Section 2: Spotfire In Depth
12
Section 3: Databases, Scripting, and Scaling Spotfire

Slicing and dicing data using hierarchy nodes

As we mentioned previously, Spotfire expressions do not work in the same way as Excel formulas. Expressions must work over the whole of the data that's currently in scope (be it the whole data table or a grouping within a visualization).

Spotfire provides a set of OVER functions to allow you to aggregate data over the nodes of a hierarchy in a data table. At its simplest level, the OVER function is a means to define at what granularity you wish to aggregate values.

The nodes of a hierarchy are the unique values in each level of the hierarchy. Perhaps the easiest type of hierarchy to think of is a date. The levels of the date hierarchy could be year/month/day. The nodes at each of the levels are the unique values at each level in that hierarchy. So, given a date column, you could imagine the nodes as the individual boxes that are...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY