Error "The external data source does not support OVER expressions" when creating a calculated column using external data in 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)
  • https://docs.tibco.com/pub/sfire-analyst/10.10.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=ncfe%2Fncfe_using_expressions_on_aggregated_data_the_then_keyword.htm
• Working with In-Database Data (TIBCO Spotfire Analysts User's Guide)
  • https://docs.tibco.com/pub/sfire-analyst/10.10.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_working_with_in-database_data.htm