Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Ideas

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...
over 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....
over 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 ...
over 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...
almost 8 years ago in Spotfire Data Virtualization / sql support 0 Future Consideration

add functionality to replace values on multiple-selected rows.

Please add functionality to replace values on all multiple-selected rows. Currently user has to replace the value on each row 1 by 1, they want to replace all values in all selected rows at once.
almost 4 years ago in Spotfire / Data Management 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...
almost 10 years ago in Spotfire / Data Management 1 Future Consideration

eliminate the difference on number formatting between Windows and Linux

According the product document, there is a difference on number formatting between Windows and Linux, l https://docs.tibco.com/pub/spotfire_server/12.0.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/running_web_player_or_automation_serv...
almost 4 years ago in Spotfire / Data Management 0 Future Consideration

Ability to replace empty cells by a value in PIVOT transformation

When pivoting tall tables to make them wide, we end up with lots of empty cells that correspond to combinations that do not exist in the original tall data set. It is now very difficult to replace these empty values by a valid value (like 0) ... s...
about 8 years ago in Spotfire / Data Management 0 Future Consideration

Server Side Event adapter

Adapter for SSE (server side events)
about 6 years ago in Spotfire Streaming 1 Already exists

Warning when Right or Left Join adds rows to data table

I think it would be great if Spotfire would warn me when an insert column operation will add rows to the data. Sometimes this is intended, but other times, it is because there is a problem in the data quality. In my use case, adding rows is usuall...
over 8 years ago in Spotfire / Data Management 0 Future Consideration