Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...
over 6 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

show more information in data loading dialog

Currently we can get below information in data loading dialog when opening analysis or loading data, \! filetype=Spotfire.DataFormat.Text; version=2.0; \! property=Name; category=Column; type=String; \! property=DataType; category=Column; type=S...
over 4 years ago in Spotfire / Data Management 0 Future Consideration

Add match columns dialog when replacing a single datasource within a larger joined datatable

If you need to replace a single datasource that is joined to multiple other datasources in a data table there is no way to match your existing columns to the new datasource columns as the match column dialog is only available when there is a singl...
over 5 years ago in Spotfire / Data Management 1 Future Consideration

Add YearAndMonth and Trunc Funtion

I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both toda...
over 8 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Spotfire 10 - Bring back the reload data icon

Hi, I'm newly upgraded to Spotfire 10. The reload data icon / menu item is gone. I can only find it via the search bar. I miss the quickness and ease of one click, rather than going to the search bar, typing enough, waiting for it to load and then...
over 7 years ago in Spotfire / Data Management 2 Will not implement

LongInteger is missing in Register Data Functions menu

In case I have a column define as LongInteger data type, then I create a new function and insert an input parameter as type "Column". We noticed the following: 1. LongInteger is missing in the allowed data type list. 2. I'm not able to select the ...
over 9 years ago in Spotfire / Data Functions / Data Management 0 Future Consideration

Need Refresh/Reload Button or Icon in Filter Panel

Similar to 'reset visible filter' need a button for 'reload' of latest data from database. Right now we have to write custom scripts to pull the latest records on webplayer. All of our users access reports on webplayer/browser in production env. h...
over 6 years ago in Spotfire / Data Management 1 Future Consideration

Transpose whole data in the Data Table

No description provided
over 10 years ago in Spotfire / Data Management 1 Future Consideration

Check data (during load) for quality and changes in column values

Users appreciate Spotfire’s ability to match column name changes during data reloading. This ideas proposes the ability for Spotfire to check data (during load) for quality and changes in column values (especially when metadata changes or when dat...
almost 2 years ago in Spotfire / Data Management 0 Future Consideration

Enhancement Request - Officially Support use of IN Operator

Request for Spotfire to "officially" support the use of the IN operator in the Spotfire Expression Language. For example:CASE WHEN COLOR IN ('RED', 'BLUE', 'GREEN') THEN TRUE ELSE FALSEEND I've written code that uses IN () and it *appears* to work...
almost 10 years ago in Spotfire / Data Management 2 Future Consideration