Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Management

Showing 293

Add summary rows to table or visualization

In Spotfire, it is currently possible to add additional columns with calculated columns. I need to be able to do something similar with rows. I am working with financial data -- revenue, expenses, etc. Most of these reports are done in cross table...
almost 8 years ago in Spotfire / Data Management 0 Future Consideration

Enable mass rename of columns during the transform data process

Multiple data tables are often joined using the "Add as columns to" option. Often, the data sets being appended have the same value column names (ex. $, $ YA, Units, Units YA) which results in the subsequent data value columns having ([%C (n)]) or...
over 4 years ago in Spotfire / Data Management 0 Future Consideration

Enable global/local config to set the default formatting for Data Type

Scenario Data Table with a date-type column, formatted as YYYY-MM-DD - e.g., 2023-06-20. Goal Convert the date to string, with format retained. Current State Two-step workaround: 1. Convert Date format to YYYY-MM-DD via Data > Column property. ...
almost 2 years ago in Spotfire / Data Management 0 Future Consideration

Data Canvas UX: Column datatype formatting inside Data Canvas

See attachment The Data Canvas is a great place to manage, wrangle, cleanse, and enrich data. However, the options for formatting column data types are not found within it. You must leave the canvas and go to the Data Panel column handler then s...
over 6 years ago in Spotfire / Data Management 2 Future Consideration

Visualization data as data table in Spotfire

Often we need access to the aggregated data from a visualization. E.g. for an external tool; or for reporting; or for input to a data function. We should have the ability to have the aggregated (plot) data available as a data table in Spotfire. It...
over 6 years ago in Spotfire / Data Management 0 Future Consideration

Setting for Case sensitivity

Currently Spotifire is Case Sensitive which makes aggregations at certain level harder to manage. While you can do all sorts of string manipulation it would be nice to have a setting to turn on/off case sensitivity. For example , if you aggregate ...
over 8 years ago in Spotfire / Data Management 1 Future Consideration

Impact Analysis in Calculated Colomns

hello Sometime we need to do some clean up in the calculated colomn, or delete an import colomn. Today, we must look at every calculated colomn to know where it is used. Could we have (like in Information link) a right click button to ask "Where i...
over 7 years ago in Spotfire / Data Management 0 Future Consideration

Add a Random Function

Hello We need a real random function, that would create a random integer number for each line of our data table. Every time the user would open a DXP file, the random generated would be different. We tried with Rand(count()), but the numbers gener...
about 7 years ago in Spotfire / Custom Expressions / Data Management 0 Future Consideration

Custom Query Tab in the Data Connection should Support Advance SQL like using "WITH" Clause as well as Multi SQL Statements

In order to add more extensibility to the SQL the Custom Query Tab of Data Connection should support Advance Queries like using the "WITH" Clause which is currently not supported in Spotfire Analyst. Also, if my query demands some creation of Temp...
about 8 years ago in Spotfire / Data Management 0 Future Consideration

Add colomn description in Data Panel or Filter Panel via Tooltip

Hello We can add useful description on colomn when creating a query (information link).But user can't see it ! Could it be possible to show it via Tooltip when you pass your cursor on the colomn name (or a special small button), in Data Pannel or ...
about 5 years ago in Spotfire / Data Management / Filters 0 Future Consideration