Custom Expressions

Showing 137

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

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

IFERROR Function

Adding a IFERROR function (similar to the one in Excel). This helps when analyzing data and prevent dividing by zero issue.

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

1 VOTE

Allow transformations for external (in-db) data tables

One should have the possibility to define transformations on data canvas for external (in-db) tables. Also a possibility to review the data should be possible.

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

1 VOTE

Do not automatically generate cluster columns after dendrogram clustering in heat map

I find it a bit annoying that cluster membership columns are automatically generated if I calculate dendrograms in a heatmap. I do this in order to group the rows/columns, not to calculate clusters. There should be an option to inactivate the colu...

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

1 VOTE

Community Expression in Product

Let's allow expression functions to be contributed by the community. Allow pluggable expression code; Python or IronPython or Spotfire expression syntax; Needs new API

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

1 VOTE

Improve Lag/Lead Functions

Now implemented but documentation doesn't specify how the ordering of rows is important; in addition, the ordering of rows is not guaranteed, so the functions are not trustworthy at present

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

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

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

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

Please enter your email address

FILTER BY CATEGORY