Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146
148 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 8 years ago in Spotfire / Custom Expressions 12 Future Consideration
117 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 8 years ago in Spotfire / Custom Expressions 1 Future Consideration
106 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 9 years ago in Spotfire / Custom Expressions 1 Future Consideration
103 VOTE

Save expressions /formulars in a central location in the library

In the section where you can insert calculated columns you can re-use previously used expressions. This is a handy feature. However, it shows all recent expressions. There is no option to include only the ones you want to be remembered. Hence Spot...
about 6 years ago in Spotfire / Custom Expressions 2 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...
almost 9 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?
almost 4 years ago in Spotfire / Custom Expressions 4 Future Consideration

Way to calculate number of working week day

We're looking for a simple way to calculate the number of working weekdays. In Spotfire, there is no simple function, but in Tableau, there is a "Weekday"DateDiff("weekday",[ORDER DATE],[DELIVERY DATE])In Spotfire, the closest I got is this refere...
over 7 years ago in Spotfire / Custom Expressions 3 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.
over 4 years ago in Spotfire / Custom Expressions 1 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(...
almost 4 years ago in Spotfire / Custom Expressions 4 Future Consideration

Override current culture when calculating week numbers

How week number are calculated in Spotfire depends on the current culture/locale settings in Windows. This means that the week number in Spotfire will be different on a US/English version of Windows than it would be on a Swedish version. I want to...
almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration