Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Choose type of column when replacing data in Business Author

When you replace your data in the Analyst, your are able to chose the type of column. It is not possible with the Business Author. When your column contains integer and text, the column becomes integer and you loose text data
over 6 years ago in Spotfire / Data Management 0 Future Consideration

Ability to filter the rows in a data table when using as a source for the next data table

It would be a good functionality to have if we can restrict the rows in the data table via a transformation when we use that as a source. Lets say I have a DT "A" with 1mil rows and I want to do a separate analysis with certain set of rows - so I ...
over 9 years ago in Spotfire / Data Management 3 Already exists

Sort order of columns in Column Properties

When we use Properties > Columns, it would be very usefull if we could sort the order of the columns. Today, it just add next and next... and it become hard to use. (Calculated, imported, Hierarchy, etc.) Some properties have the research mod...
over 9 years ago in Spotfire / Data Management 0 Future Consideration

Independant scheduling of data tables in a visualisation

If a visualisation contains 2 or more data tables, it will be great if we can schedule the caching of data for one of the tables while allowing the others to update data as if they're not scheduled.
over 9 years ago in Spotfire / Data Management 1 Future Consideration

Highlight new data

Scientists would benefit from this as it will enable rapid identification of a new data in large data sets. The tool would compare new data table with old one, and the new data cell would be colour-coded or visualised in a different way. On our pr...
over 6 years ago in Spotfire / Data Management 3 Future Consideration

Divide a Timespan with an Integer

When working in mobile data, we need to divide Communication time (timespan) with number of Call (Integer). Today the solution provide with conversion are far too complex for users.
almost 10 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

Join Table where Empty Values are Treated as Wildcards

When joining tables in Spotfire, add an option where empty values are treated as wildcards. There's the option for "Treat empty values as equal" but this would only return the case if both tables had empty values for the matched field. If the valu...
over 3 years ago in Spotfire / Data Management 0 Future Consideration

Better doc examples for functions.

When we are in the "Custom expression" view, we can make a search for built-in functions. We get a nice description of what it is supposed to do. Then, there is always a section "Example". The big flaw of this section is that it only shows an exam...
over 6 years ago in Spotfire / Data Management 0 Future Consideration

Data On Demand SQL Optimization - Limit by Filtered Rows

We use data on demand with "Limit by Filtered Rows" from a lookup tabl quite frequently to allow users to define the data set that is loaded and mange data size. Typically there are multiple filters with a large number of unique values. When the u...
almost 10 years ago in Spotfire / Data Management 0 Future Consideration

Marked Row DataTransformation in Data Canvas/IronPython API

Scenario Given a DataTable with marked rows, goal is to add a DataTransformation or other DataFlow step in Data Canvas or via IronPython API to obtain the said table containing only the marked records. Current approach uses a Data Function to get ...
over 3 years ago in Spotfire / Data Management 0 Future Consideration