Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146 of 4418

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 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Create new "Tall" data table when using One-Click Unpivot

The One-Click Unpivot feature transforms data from the "wide" to the "tall" format. When it does so, it transforms the existing data table. On occasion, it is helpful to have both the original wide format as well as the new tall format. My request...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Text Function - Calculated column - InitCap String Function

Objective to make the string init caps. Eg. Alpha We have a workaround where we can take the 1st character of the string and make it upper then append it it would be great, if we have in built function making first char of a string upper and oth...
over 8 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 8 years ago in Spotfire / Custom Expressions 2 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 8 years ago in Spotfire / Custom Expressions 2 Future Consideration

Filter data by expression prior to pivoting

Currently, creating a pivot table requires the entire source table to be used for the pivot when I frequently would only like a specific subset of data to be pivoted. An option to use a custom expression to filter the data prior to pivoting would ...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

For String columns in Data Panel, show counts for each unique category value

For number columns in data panel, a histogram is shown to visualize the data distribution. We also need a similar way to visualize the distribution of data for string columns. The way to do this is to visualize the counts for each unique category ...
almost 9 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 (...
almost 9 years ago in Spotfire / Custom Expressions 4 Future Consideration

Import a list of tags

Create a list of tags from a table (based on values from a column) instead of raising tags one by one.
almost 9 years ago in Spotfire / Custom Expressions 5 Future Consideration

Add expression function to convert Temperature

This is one of those simple things that you'd think would be in the tool already, but just isn't. Here's an example of how it's implemented in Excel. I would use the exact same approach. https://www.extendoffice.com/documents/excel/1254-excel-conv...
almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration