Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

AI support for creating custom expressions

I would like help to build Spotfire custom expressions for visualizations and calculated columns, especially more complex ones using OVER. This would make me more productive with Spotfire.
27 days ago in Spotfire / Custom Expressions Future Consideration
151 VOTE

Use a Calculated value in a Property

There are at least three areas that I can currently create a calculated value. Text Areas Inputs for Data Function Graphical Tables However, if I want to have a Document Property to contain a calculated value, I can't do it without running some ...
over 10 years ago in Spotfire / Custom Expressions Future Consideration
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...
almost 10 years ago in Spotfire / Custom Expressions Future Consideration

Provide The Ability to Insert / Move "Add Calculated Columns" at Data Table Level

When we use data transformations "Calculate New Column", you have the ability to move or insert as needed. However at the Data Table level, you can only Add Calculated Column one at time. You do not have the ability to Insert / Move them. It would...
2 months ago in Spotfire / Custom Expressions 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...
over 10 years ago in Spotfire / Custom Expressions Future Consideration

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...
over 10 years ago in Spotfire / Custom Expressions 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 Future Consideration

should be telling us invalid part of the custom expression visually, not in writting

When an expression written in the custom expression is incorrect or when a function is invalid, an error is displayed with a red exclamation mark which telling us wrong part in writting, not visually. However it is not clear which part of the expr...
over 3 years ago in Spotfire / Custom Expressions Future Consideration

Makes the fields in the BinByDateTime() function dependent like YearAndWeek()

To meet the user calendar, the user needs to make registry as the following: iFirstWeekOfYear=2. And iFirstDayOfWeek=0. (Monday) Function BinByDateTime("1/1/2021 1:01:01 AM","Year.Week",1) will return this value: 2021.53 While using YearAndWeek(...
over 5 years ago in Spotfire / Custom Expressions Future Consideration

Spotfire Analyst - Native conversion function for date in ISO 8601 format

There is no current built in function to convert a string containing a date in ISO 8601 format. Could TIBCO create this conversion function? This would avoid using substrings and DateTime. Thank you for your consideration.
about 6 years ago in Spotfire / Custom Expressions Future Consideration
The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved. This page and your use is governed by these Terms of Use.