Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 143 of 4232

Expression Editor Enhancements - Hover-over information for functions

Multiple teams in our organization struggle with using the expression editor. One enhancement that gets mentioned is some kind of hover-over, context sensitive help when editing expressions. For example, hovering over a function name for >2 sec...
over 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add EOMONTH (end of month) calculation function

EOMONTH() is a common Excel function because in many cases, users (all Oil & Gas industry) need to compute information based off the end of the month. Currently a typical user will not know how to compute the End of the Month using formulas be...
over 2 years ago in Spotfire / Custom Expressions 1 Future Consideration

web client support for statistical tools

It would be useful to be able to invoke the Spotfire Statistical tools from the Web Client. This would allow creating new Classification and Regression Models as well as using Line similarity and Clustering.
over 2 years ago in Spotfire / Analytics / Custom Expressions 0 Future Consideration

Make STRING_AGG available as aggregate function for In-Database connections

SAP HANA supports STRING_AGG function. https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/a924ee1e98ab435a874efa32e6f0ae14.html Also SQL Server and Azure Synapse support STRING_AGG https://docs.microsoft.com/en-us/sql/t-sql/...
over 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Differences between Preprocessor ($) and Document Property in custom expression

End user can insert a document property into an expression using the Insert Property option in the calculated column expression. This would add a preprocessor($) expression like ${documentproperty} When renaming a column name, the expression using...
about 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

Makes the fields in the BinByDateTime() function dependent like YearAndWeek()

To meet the user calendar, the user needs to make registry as the following: iFirstWeekOfYear=2. And iFirstDayOfWeek=0. (Monday) Function BinByDateTime("1/1/2021 1:01:01 AM","Year.Week",1) will return this value: 2021.53 While using YearAndWeek(...
over 3 years ago in Spotfire / Custom Expressions 4 Future Consideration

Crosstable aggregate function for totals

I need to show the average of the row values in a cross table. The only option is a total as a sum, but what I really need is the average. In Tableau I could do this easy, when will Spotfire add this?
over 3 years ago in Spotfire / Custom Expressions 4 Future Consideration

Can you please add SIGN function to the math functions?

No description provided
over 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

Create Calculated Column from other table

Currently I don't see an option in Create Calculated Columns dialog box to create calculation based on data from other tables. It would be a lot helpful to have this feature especially when you want to create calculations based on data from multip...
over 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

Use List Document Property in SQL "IN" Statement within Custom Expressions

It would be useful to be able to pass a list type document property (e.g. "String List", "Date List", etc...) into a SQL "IN" statement in a custom expression or calculated column. This can then be used to provide input for options for consumer us...
over 3 years ago in Spotfire / Custom Expressions 3 Future Consideration