Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4796

Make a Property's DisplayName usable in custom expressions

When using properties in custom expressions, one can only use the value of the property, not the DisplayName. This would be extremely useful to allow interaction with the DisplayName, particularly when using Expressions in Properties.
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

Sort within a hierarchy

When a hierarchy is used in a bar chart category axis, and then the bars are sorted by value it sorts all the bars by absolute value, without any consideration for the hierarchy. This is not ideal as the reason for setting-up the hierarchy at time...
over 9 years ago in Spotfire / Custom Expressions 2 Future Consideration

Create Calculated Column from other table

Currently I don't see an option in Create Calculated Columns dialog box to create calculation based on data from other tables. It would be a lot helpful to have this feature especially when you want to create calculations based on data from multip...
almost 5 years ago in Spotfire / Custom Expressions 1 Future Consideration

Sor values in a column by values in another column

Say you have a month name or some period indicator like 'MAR-16' as a column. Then in the dataset there would be maybe another column with a time stamp. I would like to be able to sort the period indicator column by the values in the time stamp co...
over 9 years ago in Spotfire / Custom Expressions 2 Future Consideration

Import/Export calc columns in Spotfire

It would be great, If we have import/export option in Column properties. This option required only for calculated column. It should allow to export calc columns and expression from DXP. And also, able to import calculated column from another DXP. ...
over 9 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Add in the operator/function Between

SQL has a Between option. Spotfire could also benefit from a Between. We would use Between in case statements, if statements, or as standalone logic. Today we write: If([Data] >=1 and [Data] <= 2,true,false) This could be updated to be:If(Be...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

Ability to refer to filters in any custom expression

Goal: Currently custom expressions in calculated columns cannot refer to filtering schemes to find out whether a given row is filtered in or out. Also custom expressions in visualisations can only refer to their visualisation's filtering schema (...
over 9 years ago in Spotfire / Custom Expressions 4 Future Consideration

Have the same drilldown options for fiscal years as for calendar years

It would be great to be able to use the same date drilldown options in fiscal years as we can for calendar years, i.e. Fiscal Year > Fiscal Quarter > Month > DayOfMonth, and Fiscal Year > Month > DayOfMonth, or DayOfWeek. My compa...
almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

Principle Component Analysis - bring it back to Spotfire

For big data exploration in healthcare, I am using spotfire now since 2001. One of my favorite pieces of software. After uprgrading from 7.11 to Spotfire Desktop 11, Principle Component Analysis (PCA) went missing. Its a key feature in summarizing...
almost 4 years ago in Spotfire / Custom Expressions 2 Already exists

Output Holt-Winters forecast as calculated column

Just discovered the Holt-Winters forecasting implemtation in charts and find it extremely useful. However, it seems as if it was not possible to also get the forecasted values as a calculated column. This would be required to e.g. do some error co...
almost 7 years ago in Spotfire / Custom Expressions 0 Future Consideration