Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

My ideas: Custom Expressions

Showing 136

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

Lastperiods() with negative period numbers

Hi, The lastperiods function can only accept positive first parameter (which indicates the number of periods to include in the calc (as opposed to the previousperiod function which can take negative arguments). if you tried to use this function i...
about 7 years ago in Spotfire / Custom Expressions 1 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
almost 2 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
almost 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allow the creation and definition of some enterprise document properties

Many reports can draw on the same document definitions that need to be recreated in each new analysis, or a template is required to predefine them. There is already on e enterprise document property "Financial Offset". Similarly, it would be conve...
over 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

Date diff function excluding weekends (Working days)

DateDiff - function is used to find the ageing between start date and end date but it includes weekends. Spotfire should add a new functionality in DateDiff function which accepts are parameter to exclude weekends and find working days ageing. D...
over 7 years ago in Spotfire / Custom Expressions 3 Future Consideration

display of common mathematical expressions based on highlighted data

Would like to highlight data on a graph, and have Spotfire tell me things like the Average, Mean, Max, Min without having to code. I should be able to Display or Hide the "Stats" window, and based on what I highlight in the graph, it calculates th...
almost 6 years ago in Spotfire / Custom Expressions 1 Future Consideration