Spotfire Analytics and Statistics Flashcards

What does the OVER function in Spotfire expressions allow you to compute?

Answer: Aggregations scoped to a specific set of columns (window/grouping context)

OVER performs an aggregation partitioned by specified columns, similar to SQL window functions, without collapsing rows.

In Spotfire, what does the function 'Rank([Value]) OVER ([Category])' compute?

Answer: Rank of each value within its category group

Using OVER partitions the ranking by the specified category, so each group gets its own independent rank sequence.

Which Spotfire function returns the value of a column from the previous row when data is ordered by a specific column?

Answer: Lag

Lag retrieves the value from a preceding row by a specified offset, useful for period-over-period calculations.

What is the purpose of the 'NodeId()' function in Spotfire's expression language?

Answer: Returns the internal row index identifier for each row

NodeId() returns Spotfire's internal zero-based row index, useful for uniquely identifying rows in expressions.

In Spotfire, what does 'Correlation coefficient' as a trend line statistic measure?

Answer: The strength and direction of the linear relationship between X and Y

The correlation coefficient (r) ranges from -1 to +1 and quantifies how strongly and in which direction two variables are linearly related.

Which Spotfire feature enables running R or Python statistical models directly integrated with visualizations?

Answer: TIBCO Enterprise Runtime for R (TERR) data functions

TERR (TIBCO Enterprise Runtime for R) allows R scripts to be embedded as data functions, processing Spotfire data and returning results back to visualizations.