Custom Expressions

Showing 146 of 4418

allow to view and select unique data values of selected column when writing expression.

sometimes, when we are writing an expression, we used the values of the column so if it can be autocompleted or displayed unique values and let the user copy it, it will be very useful. for example: [Country] != "Egypt", if I select column [countr...

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

2 VOTE

Add a "Proper" function

The upper and lower functions are very useful. It would be helpful to also have a "proper" function similar to what is done within Excel to convert the first character of each word to upper case and all other characters to lower case.

over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

22 VOTE

Additional string function where you are able to change the rounding settings

Belongs to the article https://community.tibco.com/questions/rounding-issue-string-function. If you use a numeric column and convert the result to a string column, there are always only 2 decimals shown. For calculating P values you´ll need 4 dec...

over 7 years ago in Spotfire / Custom Expressions / Data Management 6 Future Consideration

2 VOTE

Custom expression function to format data(numeric/datetime,etc) like String.Format([column], "c# format string")

It's good to have custom expression function to format data like String.Format([column], "c# format string") in custom expression or calculated column. Thanks.

over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

Fix reaction of Sn() to (Empty) values

There are some (Empty) values resulting from joins e,g, within Graphical table to which SN() does not apply. See this thread https://community.tibco.com/questions/empty-value-does-not-react-sn

over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

6 VOTE

Time zone conversion function

Currently we have the timezone conversion set up on database side, but if the user wants to change the timezone, then this will restart the pain stacking data import. One can solve it robustly by adding timezone difference with the DateAdd functio...

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

3 VOTE

Built in conversion for Date strings in serial format

There doesn't seem to be any way for Spotfire to take a date string in serial format (41397) and convert it into a working date. I know when the data table is being uploaded, it can be registered as a date and will be converted. For the purpose of...

over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

1 VOTE

Adding Fiscal date hierarchy

Hi, All our analysis is based on Fiscal calendar. To get this filter I need to create three separate columns (one each for year, quarter, month) and combine them as hierarchy hence creating unnecessary data columns and too much of work as we have ...

over 7 years ago in Spotfire / Custom Expressions 1 Already exists

5 VOTE

[Current Filtering] available in calculated column

Would be nice to be able to adjust a calculated column in an OVER expression using the current filtering

over 7 years ago in Spotfire / Custom Expressions 1 Will not implement

1 VOTE

Sum in a custom expression using Intersect

Currently Max in a custom expression using intersect will work properly. Sum does not. This would be beneficial for things like dynamically calculating error rates based on user selections. I.e. aggregating variances at any level and summing those...

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

Please enter your email address

FILTER BY CATEGORY