Custom Expressions

Showing 146

Better decimal point accuracy on color rule for column created through a custom expression

I have created a percentage value as part of a custom expression - and within the Formatting menu, this field has been setup as a "Percentage". When I create a new color rule using this column, it allows me to enter decimal based values into the r...

over 4 years ago in Spotfire / Custom Expressions 2 Already exists

1 VOTE

Concatenate for external data Oracle

I have connected to Oracla table using custom query and keeping data external. I would like to create a calculated column using Concatenate, but both concat([column1],[column2) and Concatenate([column1],[column2) are not accepted by the expression...

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

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

1 VOTE

Remove comments from resulting expression

The resulting expression rendering box is very useful to me when debugging or creating custom expressions. It would be nice not to render the comments on my custom expression on the resulting expression box as shown here

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

3 VOTE

Show available functions for an In-Database Connection to SAP HANA

Functions like Case, If, All, AllPrevious Over etc. all work in Spotfire for in-database connection to SAP HANA. But they are not shown in the list of functions available. Our users need an easy to use interface without getting into details of wha...

almost 8 years ago in Spotfire / Custom Expressions 2 Future Consideration

3 VOTE

Refer to Marked items in a custom expression

The should be a way to refer to marked items in a custom expression. for example: sum(if([field1] in marking, 1, 0)) as [var1], sum(if([field1] not in marking, 1, 0)) as [var2] where marking is selected in a different visualization. I know that I ...

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

3 VOTE

Remove function overwrite in calculated columns and custom expressions

Currently if you type in an expression for a calculated column or a custom expression and then go back to the beginning of an expression and type another function, the original function gets overwritten. This is very annoying. I would like this fe...

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

3 VOTE

Divide a Timespan with an Integer

When working in mobile data, we need to divide Communication time (timespan) with number of Call (Integer). Today the solution provide with conversion are far too complex for users.

about 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

3 VOTE

Select data table from custom expression dialogue

When using multiple data tables and trying custom expression there is no way to manually select the data table from which to select the column. You can change the data table that is shown on the custom expression menu by going to Edit>Data tabl...

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

2 VOTE

Date Math Functions supported for In Database Connections

Most modern databases (sql server, oracle, teradata, cloudera, etc) support some level of date manipulation functions like dateadd(), add_months(), datediff(), getdate(), etc. Currently Spotfire doesn't support any of these functions across the ma...

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

Please enter your email address

FILTER BY CATEGORY