Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Analytics

Showing 358

Set Default Color For Categories

Frequently, there are specific colors that I want to use for certain dimensions in my data. For instance, if I have credit card transaction data, and I want to break things out by 'Card Type', I should be able to set "AmEx = Green", "Visa = Blue",...
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

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.
over 8 years ago in Spotfire / Analytics 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/...
almost 3 years ago in Spotfire / Custom Expressions 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 ...
over 8 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 "#.# %"' ?)"
over 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Add ability to reference already created values that are defined in a custom expression

Being able to reference already created values that are defined in a custom expression. For example you might use the below custom expression code. I will create an average voltage and standard deviation voltage variables for my typical process. I...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

Allow OVER functions to access multiple aggregations and allow multiple OVERs per Custom Expression

Currently the OVER function is, frankly pretty poorly implemented for anyone wanting to do data analysis that's not time series data. OVER functions should be able to access aggregations in parenthesis. For example, if I wanted to calculate the av...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

add support for latest rJava package to Statistics Services

On TSSS 12.0LTS, The supported R and rJava versions are quite confusing. R up to latest 4.x versions are all supported but supported rJava version is too old and it can not be installed into R versions later than 4.0.2. https://docs.tibco.com/pub/...
over 1 year ago in Spotfire / TIBCO Enterprise Runtime for R 0 Future Consideration

calculate over all periods of detail levels

Lets say we have a hierarchy of Year.Month, we want to calculate sum on all the same months (e.g. March) of each year. ParallelPeriod() can only calculate on the same month of previous year.
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

Favorite registration and Export/Import functions for saving time to create same expression

I need favorite registration and Export/Import functions for saving time to create same expression. Often the same calculation new column is created and applied to several different analyses. In this case, the history function "Recent expressions"...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration