Missing greater and less than operators from visualization limit data using expression

[Jason Elkin]

I'm attempting to limit a visualization using the limit data using expression. The dates are pulled from a propterty control. When I open the "limit data using expression" within the data table properties various functions are no longer visible. The logical operators of greater than, less than, or equal too are missing and not recognized. Date functions are also missing such as "Date" or "DateTime".

The store data option is set to "Linked" insted of imbedded in the analysis. Like some tables, I wasn't sure if this version of communicating with information could limit some of the logical operators available when writing custom expressions Thank you for your help

[Kirsten Smith (she/her)]

If you click on Help/Help Topics and look under the Index tab for:

 

In-database data/working with

 

you'll see details about what you can and cannot do with in-db data.

[Shashank Gurnalkar]

Not all of the standard Spotfire aggregation methods and expressions are available on all external systems. On the other hand, there may be other methods available that Spotfire does not have by default. The aggregation methods supported by the external data source determines which methods will be available for in-db data. You can refer to this documentation for information on working with in-db data.

https://docs.tibco.com/pub/sfire-analyst/10.8.0/doc/html/en-US/TIB_sfire...

[Jason Elkin]

Thank you, info was very helpful

[Jason Elkin]

Thank you for your help