Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 143

Add an aggregation method to find the Nth most common value

MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...
10 months ago in Spotfire / Custom Expressions 2 Future Consideration

Allow axis in a visualization to be used as a part of an OVER expression regardless of axis type

Currently, an axis has to be of type Categorical for it to be available in an Custom Expression with OVER() - e.g., [Axis.X] - in a given visualization. However, to add Line and Curves in the same visualization, the axis has to be Continuous. Enab...
5 months ago in Spotfire / Custom Expressions 0 Future Consideration

Persistent ascending/descending sort order for column values

I want to change sort order for column values to ascending/descending. I also want new inserted rows to take account of the sort order set for the column values. Solution with todays design: Descending column values can be achieved by using "Edit ...
over 8 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...
over 3 years ago in Spotfire / Custom Expressions 1 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...
about 8 years ago in Spotfire / Custom Expressions 2 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...
about 8 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....
almost 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Integration of Seaborn, Plotly, Dash, Pandas,Numpy etc with Spotfire

There are various lib which we can use to ease data manipulation and visualization, it will add more value if integration is provided for such libraries.
over 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Differences between Preprocessor ($) and Document Property in custom expression

End user can insert a document property into an expression using the Insert Property option in the calculated column expression. This would add a preprocessor($) expression like ${documentproperty} When renaming a column name, the expression using...
over 3 years ago in Spotfire / Custom Expressions 1 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 ...
about 8 years ago in Spotfire / Custom Expressions 4 Future Consideration