Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Ideas

Showing 751 of 4805

Data wrangling function to merge multiple dataframes to fill and replace

Often, multiple sources of data have different level of 'complete cases' - dataset #1 may have 60% filled entries, while dataset #2 may have the remaining 20% that are missing from #1 (both datasets may have all or some columns matching). Currentl...
almost 9 years ago in Spotfire / Data Management 2 Future Consideration

Store calculated columns in data connections

If you have a lot of calculated columns in your analysis file, it's frustrating that the only way to share these is by duplicating the analysis file. If they could be stored in data connections these could be reused across multiple dashboards. The...
about 7 years ago in Spotfire / Data Access / Data Management 0 Future Consideration

Add an Ignore Zeros option in an Unpivot transformation

I often have a table with a large number of zero values ( rather than null values) in soem columns that I then need to Unpivot. This results in a table with a large number of rows where the valu column is zero and this impacts overall performance....
about 7 years ago in Spotfire / Data Management 0 Future Consideration

Split a column into rows

I have a column with multiple values inside, with a separator between each value. The number of values is not the same on every row. If I use the standard split column feature, I will generate a number of columns corresponding to my max number of ...
about 7 years ago in Spotfire / Data Management 2 Future Consideration

Allow virtual columns to support IN clauses/multiple value filtering

We have customers using virtual columns in an SQL view, e.g: Select *, {DECLARE p_postdate date } p_postdate from table where post_date=p_postdate This functionality needs to be expanded to support multiple values pf p_postdate (i.e, an IN claus...
about 7 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

Simple master data editor (edit data table)

Spotfire can store data in library but this data cannot be modified directly. In many cases user needs to create simple master data or mapping tables which are stored on local drives in excel or other formats. This has many drawbacks. Users can up...
about 9 years ago in Spotfire / Data Management 0 Future Consideration

ability to configure ListBoxFilter as the default filter type for all category columns

Customer wants to have the ability to configure ListBoxFilter as the default filter type for all category columns. Currenly it seems filter types are determined by the count of unique values in each column. 1<= count <=10 => CheckBoxFilte...
almost 2 years ago in Spotfire / Filters 0 Future Consideration

Hide Repeating Hierarchy Levels

Flat ragged hierarchies often repeat values at lower levels due to different drill down paths. It would be very nice to have the options to hide levels if the parent has the same value. Currently I have to click down through many repeating levels ...
about 9 years ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

Federated Open Search in DV?

When we make connection in Salesforce for External Data Sources.There are two types can be selected:1. Odata2. FederatedOpenSearch Odata connection to access TDV virtual database is fully functional however second option FederatedOpenSearch is not...
almost 2 years ago in Spotfire Data Virtualization / data sources 0 Future Consideration

Define tables as staging or reporting

Not all tables that are created in a Spotfire analysis are there for reporting purposes. Some tables are only for transforming data or loading data. The content of these tables is in the end, when all the loading, calculating and transforming is d...
over 9 years ago in Spotfire / Data Management 1 Future Consideration