Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 139

IFERROR Function

Adding a IFERROR function (similar to the one in Excel). This helps when analyzing data and prevent dividing by zero issue.
about 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

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.
about 3 years ago in Spotfire / Custom Expressions / Data Streams 0 Future Consideration

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

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 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

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 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

As a report developer I would like to be able to add rows from an information link so that I can create analysis files for different users

*Description:*As a report developer I would like to be able to add rows from an information link so that I can create analysis files for different users This customer is sending embedded data files to different customers on a regular basis and wan...
almost 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

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 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

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 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

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 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

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.
almost 4 years ago in Spotfire / Custom Expressions 0 Future Consideration