Product: TIBCO Spotfire®
Error "The external data source does not support OVER expressions" when creating a calculated column using external data in TIBCO Spotfire.
While creating a calculated column from a data table which is being populated through a connector, OVER functionality can not be used inside a calculated column if the data table is kept as external (In-Database). The following is the error message generated.
Error: The external data source does not support OVER expressions.
When working with connectors and keeping the data table external, you have to write OVER expressions as post-aggregation expressions. Example:
Custom Expression Example: Avg([Customer_ID]) then Avg([Value]) OVER (All([Axis.X]))
- Using Expressions on Aggregated Data (TIBCO Spotfire Analysts User's Guide)
- Working with In-Database Data (TIBCO Spotfire Analysts User's Guide)