Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4796

Empty values changed to zero in cross table should be used in over calculation

In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...
almost 9 years ago in Spotfire / Custom Expressions / Visualization 0 Future Consideration

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 9 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...
about 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

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

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...
about 3 years ago in Spotfire / Custom Expressions / User Experience 0 Future Consideration

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