Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Analytics

Showing 366

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/...
about 3 years ago in Spotfire / Custom Expressions 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

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

$esc() should also take strings as argument

Sometimes it would be useful when $esc() could use a string argument instead of a property. For example to set a display name using a condition, something like the foloowing expression: [Column] as $esc(if(${property}="1","1","not 1"))
almost 7 years ago in Spotfire / Custom Expressions 0 Will not implement

Forecast even when any number of missing values between measurements.

Real data has missing values all the time (holidays, technical issues, user issues). Most data is not perfect.
over 8 years ago in Spotfire / Analytics 1 Future Consideration

Allow users to unhook embedded data function from Spotfire library

If a user has a dxp file containing an embedded TERR data function that is synchronized with the Spotfire library, the path to the library is visible in the Data Function Properties dialog. If the user makes a change to the local copy and saves wi...
over 8 years ago in Spotfire / Analytics / Data Functions 0 Future Consideration

Provide and match default input and output handlers for Data Functions

WHAT: Currently a Data Function author much specify the inputs and outputs for the Data Function, and that information is included in the Data Function definition. However, when a data function is added to a DXP (whether from a .dfd file or the Li...
over 8 years ago in Spotfire / Analytics / Data Functions 2 Future Consideration

Synchronize Data Functions with copy in library

Once a data function is loaded into a DXP from a file, it is impossible to then synchronize/link that data function with a known identical copy in the library. Would be useful to be able to re-establish this link, once it is broken. (Each copy has...
over 8 years ago in Spotfire / Analytics / Data Functions 0 Future Consideration

Keep old output columns when adding new output columns in data function

Say we have a data function that has column A as output. When the script is altered and a new column B is added as output, then an additional column A is added along with the new column B. However, as calculated columns etc. might depend on the ol...
almost 7 years ago in Spotfire / Analytics / Data Functions 0 Future Consideration

Duplicate Data Function definition

Sometimes, I want to register a data function with a script that is already present in the analysis but slightly different parameters. For this, I have to register a new data function and select all the input/output parameters again. "Copy" in the...
over 5 years ago in Spotfire / Data Functions / Scripting 0 Future Consideration