Custom Expressions

Showing 146 of 4803

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

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

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

1 VOTE

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

1 VOTE

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

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.

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

3 VOTE

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

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

Please enter your email address

FILTER BY CATEGORY