Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Analytics

Showing 345

R Syntax code checking in TERR Scripting window

Remember how I-Miner used to do a quick syntax once-over of the (S+) code before saving & closing the text window? It would be convenient if the Spotfire TERR window would do a similar once-over syntax check.
almost 9 years ago in Spotfire / Analytics 0 Future Consideration

Add the "pad" function

I would like to see the PAD (and/or LPAD/RPAD) function added to Spotfire. This is a common string function in many other DBMSs and tools. Example use case:I had a data source with one column containing SEQUENCE (i.e. integer 1-15) and another col...
over 1 year ago in Spotfire / Data Functions 0 Future Consideration

Not equal to should evaluate to true if value is null

User is stating that IF statements do not handle nulls as expected in calculated columns, or in limit data by expressions on a visualisation. Here is an example: 3 rows of data: ID Value1 Complete2 3 Not Complete Where in ID 2 , the value for the ...
almost 9 years ago in Spotfire / Custom Expressions 1 Future Consideration

Control over formatting anywhere a custom expression is used

It is quite inconvenient that anywhere you use a custom expression you can't specify the format at the same time (or is there an undocumented keyword for expressions such as '[Home Runs]/[Runs] as [Percentage] like "#.# %"' ?)"
almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Categorize data functions

i find the new data function capabilities in Spotfire really useful and the ability to pin data functions to an easily accessible data function panel is very handy. However the long list of functions looks a bit intimidating. It would make it much...
about 3 years ago in Spotfire / Data Functions 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 8 years ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

Embedding Data Functions

We use Data Functions from our server library to quickly add features to new DXP files. The issue we are having is once you add a data function to a new DXP file it keeps the server path. If someone make a change to the function and then saves, it...
about 8 years ago in Spotfire / Analytics / Data Functions 0 Future Consideration

Surface Python warnings without having to enable debugging

I think it would be very helpful for developing data functions if we could surface warnings without involving the debugging feature. Sometimes for instance there is a call to an API and that call may fail; one way of designing the code would be to...
over 1 year ago in Spotfire / Data Functions 0 Future Consideration

Make STRING_AGG available as aggregate function for In-Database connections

SAP HANA supports STRING_AGG function. https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/a924ee1e98ab435a874efa32e6f0ae14.html Also SQL Server and Azure Synapse support STRING_AGG https://docs.microsoft.com/en-us/sql/t-sql/...
over 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Move the 'freeze Column' button away from the 'Edit' button for calculated fields

I can't tell you how many times I've accidentally clicked the Freeze Column button in an analysis. This causes the data table to become embedded, and there is no way to un-embed it. Thus I lose would, and because there's no version control in Spot...
over 8 years ago in Spotfire / Custom Expressions 1 Future Consideration