Custom Expressions

Showing 144

Add in the operator/function Between

SQL has a Between option. Spotfire could also benefit from a Between. We would use Between in case statements, if statements, or as standalone logic. Today we write: If([Data] >=1 and [Data] <= 2,true,false) This could be updated to be:If(Be...

14 days ago in Spotfire / Custom Expressions 0 Future Consideration

1 VOTE

add function to update the value of document property

Please add function to update the value of document property from custome expression & calculated columns, it's very helpful in some use cases if we can assign value from data table to document property.

2 months ago in Spotfire / Custom Expressions 0 Future Consideration

3 VOTE

Make a Property's DisplayName usable in custom expressions

When using properties in custom expressions, one can only use the value of the property, not the DisplayName. This would be extremely useful to allow interaction with the DisplayName, particularly when using Expressions in Properties.

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

5 months ago in Spotfire / Custom Expressions 0 Future Consideration

1 VOTE

Allow axis in a visualization to be used as a part of an OVER expression regardless of axis type

Currently, an axis has to be of type Categorical for it to be available in an Custom Expression with OVER() - e.g., [Axis.X] - in a given visualization. However, to add Line and Curves in the same visualization, the axis has to be Continuous. Enab...

6 months ago in Spotfire / Custom Expressions 0 Future Consideration

0 VOTE

Enable caching in Expression Function

Data Function has a built-in Allow Caching option to avoid redundant run when input parameters don't change, while Expression Function does not.

11 months ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

Add an aggregation method to find the Nth most common value

MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...

11 months ago in Spotfire / Custom Expressions 2 Future Consideration

3 VOTE

Create a 'List box' property control with expression within a text area using a table apart from the default table

While working in the Property control dialog, select the property and set 'Set property value through' to 'Expressions'. However, when you attempt to Edit the Expression, only the column names from the default table are visible but not other tables.

12 months ago in Spotfire / Custom Expressions 2 Future Consideration

1 VOTE

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

1 VOTE

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

Please enter your email address

FILTER BY CATEGORY