Custom Expressions

Showing 144 of 4260

To have offset in DayofWeek similar to FiscalYear

Week day is different in GCC countries hence it will be great if we have offset option in DayofWeek function

over 2 years ago in Spotfire / Custom Expressions 2 Future Consideration

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

11 VOTE

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

3 VOTE

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

2 VOTE

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/...

almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

1 VOTE

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

29 VOTE

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

46 VOTE

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

1 VOTE

Can you please add SIGN function to the math functions?

No description provided

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

7 VOTE

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

Please enter your email address

FILTER BY CATEGORY