Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 11

Add ISOWEEK function to Spotfire

Spotfire does not currently support translating dates to ISO (8601) week numbers. The WEEK([date]) function is based on Windows location settings and does not match with ISO weeknums. Other programs (e.g. Excel) have separate build-in functions fo...
over 5 years ago in Spotfire / Custom Expressions 5 Implemented

Ability to Edit the Insert Rows Option

Currently the option to include Columns or Rows from other Data source is not editable once it is done. Insert --> Columns: 1. Option to edit the join keys 2. Option to add / remove columns Insert --> Rows: 1. Option to edit the m...
over 8 years ago in Spotfire / Custom Expressions 5 Implemented

Allow the user to change an insert columns operation without replacing a table

As the application is designed currently, you cannot change an insert columns operation once it has been added. The only way to change it is to replace the table and start over. This is extremely time consuming.
over 8 years ago in Spotfire / Custom Expressions 0 Implemented

Show/Hide a window that displayed the current filter settings.

When end user open a Spotfire file, it would be helpful if there was an option to show/hide a window that displayed the current filter settings.If this option is present inside any Menu option then end user can easily see the things if required.st...
almost 9 years ago in Spotfire / Custom Expressions 1 Implemented

Manual Aggregation in Cross Table Grand Totals.

Hi, If one of my column is calculating avg, in grand total I wanted to use sum of the above results as grand total. But, now it is calculating avg.
about 8 years ago in Spotfire / Custom Expressions 3 Implemented

Add Regression Functions

Add regression functions to be used in calculated columns or custom expression. The goal is to be able to display data or make recommendations based on the regression parameters. Examples for linear regression would be REGR_SLOPE and REGR_R2. Base...
about 8 years ago in Spotfire / Custom Expressions 0 Implemented

Make Median available as calculation function for In-database connection to SAP HANA

Median is a critical calculation method for us, because we do statistical analysis on our data. We understand, that not all of the standard Spotfire aggregation methods and expressions are available on all external systems. The reason as given on ...
almost 8 years ago in Spotfire / Custom Expressions 0 Implemented

Use "Category" and "Value" for new data columns when using One-Click Unpivot

When using One-Click Unpivot, the newly created data column names are a concatenation of the fields that have been transformed. While helpful to see exactly what columns have been transformed, the names become very long when a large number of colu...
over 8 years ago in Spotfire / Custom Expressions 0 Implemented

Multi-line field for editing document property values

Spotfire document properties is a very powerful feature with many uses. It can be used to hold column selections, and constants that affect what is displayed on a visualization axis or how a calculation is performed. It can even be used to store c...
over 2 years ago in Spotfire / Custom Expressions 0 Implemented

Make conversion functions available for in-database connection to SAP HANA

Conversion functions are absolutely necessary to combine and work with Calculated columns. Some standard conversion functions like DateTime, Integer, String are not available in Spotfire while these are available in SAP HANA and also possible to u...
almost 8 years ago in Spotfire / Custom Expressions 1 Implemented