Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Ideas

Provide metrics for DV usage

The metrics that are included in TDV out of the box are useless for longterm reporting of how TDV is being used by customers. There is a package available through Advanced Services called KPI metrics but it is not supported and we are having great...
almost 7 years ago in Spotfire Data Virtualization / monitoring 3 Planning to implement
119 VOTE

Calculated Columns that Filter With Data

Calculated Columns are powerful but often not useful if they don't recalculated based on filtered data. We've developed scrips to flag filtered records and calculate over that flag but this requires the user to click a button every time they filte...
over 10 years ago in Spotfire / Custom Expressions 1 Future Consideration
108 VOTE

Reverse Sort order option for date columns

As a user, I want to be able to sort columns including various date formats in order to view data in chronological or reverse chronological order. Should support major date formats including: January 2012January 2 20122 January 20122012 January 21...
almost 11 years ago in Spotfire / Custom Expressions 1 Future Consideration

Cache job auto-restart upon failure

We would like the option to automatically reattempt a cache job when it fails. We have some public api data sources that randomly fail from time to time, and they succeed if you just restart them. It would save us time and failure alerts if they c...
almost 7 years ago in Spotfire Data Virtualization / caching / data movement 2 Future Consideration

Add a file adapter to connect to parquet files directly

Extend the flat file support of the server to connect directly to parquet files to read in data.
almost 9 years ago in Spotfire Data Virtualization 3 Future Consideration

Truncate cache buckets instead of delete

Currently buckets have all their records deleted, and then the new records are inserted. In the database this means 2 write operations, and is a major cause of index fragmentation. Most databases allow you to truncate the table, which is only an a...
about 4 years ago in Spotfire Data Virtualization / caching 1 Planning to implement

Improve performance of query retrieving user authorization for more than 300% by removing order by statement

We discovered a Spotfire query that retrieves user authorization, which has the highest cost and is used more than 400 times an hour on our system. It contains an "order by" statement. If this statement is removed it performs 300% faster. Although...
over 3 years ago in Spotfire / Installation 7 Future Consideration

Include RIGHT function support for SQL Server adapters

We have to manually add to the sql 2016 and sql 2019 capabilities files. #RIGHT RIGHT(~date,~string): RIGHT($1, $2) RIGHT(@null,~string): RIGHT($1, $2) RIGHT(~number,~string): RIGHT($1, $2) RIGHT(~number,@null): RIGHT($1, $2) RIGHT(~any,~any,): RI...
about 1 month ago in Spotfire Data Virtualization / data sources 0 To be Reviewed

Location invariant value formats in expressions

*Goal:*As an author, I need to control the exact format of my data so that I can properly configure the rest of my analysis. Regional language and cultural settings are client dependent and therefore dates and decimal separators change depending o...
almost 11 years ago in Spotfire / Custom Expressions 2 Future Consideration

Crosstable aggregate function for totals

I need to show the average of the row values in a cross table. The only option is a total as a sum, but what I really need is the average. In Tableau I could do this easy, when will Spotfire add this?
over 5 years ago in Spotfire / Custom Expressions 6 Future Consideration