Custom Expressions

Showing 137

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...

almost 6 years ago in Spotfire / Custom Expressions 2 Future Consideration

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

27 VOTE

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...

almost 2 years ago in Spotfire / Custom Expressions 0 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

9 VOTE

GUI interface for OVER expressions

OVER expressions are extremely powerful since they can achieve the same slicing and dicing of data which you can achieve using pivot transformations but in are more interactive way operating on subsets of data tables. At the same time most users w...

9 months ago in Spotfire / Custom Expressions 0 Future Consideration

46 VOTE

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

94 VOTE

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

29 VOTE

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 3 years ago in Spotfire / Custom Expressions 4 Future Consideration

16 VOTE

Add an apply changes button to Custom Expression dialogue box

I do a lot of cross tables and other visualizations with lots of 'Columns' that are custom expressions, and often I have to go through them and make changes to one or more than one of the expressions. It would be really helpful to have a button in...

over 2 years ago in Spotfire / Custom Expressions / User Experience 1 Future Consideration

Please enter your email address

FILTER BY CATEGORY