Custom Expressions

Showing 146 of 4367

IN function like the IN operator in SQL

Ability to filter/limit data data like '[column] IN (value1, value2, ...)' this would result in a more readable construction then [column] = 'value1' and [column] = 'value2'. Work around is the to use the regular expression but that is harder if v...

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

1 VOTE

Allowing for DateTimeNow() for UTC expression

Having analysts working in different time zones, it would be helpful to have an easier way to link data from different time zones and to use UTC when analyzing the data.

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

16 VOTE

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

about 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

1 VOTE

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

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

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

about 3 years ago in Spotfire / Custom Expressions 2 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.

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

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

over 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(...

almost 4 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?

almost 4 years ago in Spotfire / Custom Expressions 4 Future Consideration

Please enter your email address

FILTER BY CATEGORY