Custom Expressions

Showing 146

Random Sample data as Transformation option

Don't think this is currently possible. Currently, to do a random sample, I create a calculated column for random value like Rand(1). Then I filter the data to my sample size (e.g. I filter out 0.0 to 0.7 if I want a random sample that's 30% of th...

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

10 VOTE

Data Table Description

I need the ability to add a detailed description of a data table in the Spotfire client. When I have multiple data tables in a complex analysis, it is easy to lose track of what purpose each data table serves. I experimented with adding a new Data...

over 8 years ago in Spotfire / Custom Expressions 1 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.

11 months ago in Spotfire / Custom Expressions 0 Future Consideration

7 VOTE

Separate the StdDev function/aggregation like Excel function

Hello, This is Nagwon Jeong. I would like to suggest one function/aggregation. In Excel, there are STDEV.P, STDEV.S, STDEVA, and STDEVPA functions to obtain the standard deviation. And the function/aggregation to get the standard deviation in ...

over 6 years ago in Spotfire / Custom Expressions 1 Future Consideration

10 VOTE

Add preferences/options on how null values should be default handled.

Add an option to Spotfire that allow you to configure how NULLs are handled when used in expressions and calculations. For instance I would like the option to specify that when using an expression or calculation, that NULLs are treated as empty st...

about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

7 VOTE

Orthogonal Distance Regression (ODR)

Hi We would like to see the orthogonal regression as an additional comparison method under Tools-->Data Relationships to add this type of regression to the data relationship tool

almost 7 years ago in Spotfire / Custom Expressions 0 Future Consideration

7 VOTE

Add a Random Function

Hello We need a real random function, that would create a random integer number for each line of our data table. Every time the user would open a DXP file, the random generated would be different. We tried with Rand(count()), but the numbers gener...

almost 7 years ago in Spotfire / Custom Expressions / Data Management 0 Future Consideration

9 VOTE

Utilize Curve Fit Result directly in another visualization.

Consume the data retrieved from “Export Curve Fit Result” directly without the need to export it and re-import it back to the analysis itself.

about 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

5 VOTE

Custom Expressions - formula in-line context

Add functionality like found in other coding languages (R, SQL, even Excel) which would show preview text when creating a new custom expression. For example: When you start typing... dateadd( you would see something like... dateadd( 'increment'...

over 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

8 VOTE

Filter data by expression prior to pivoting

Currently, creating a pivot table requires the entire source table to be used for the pivot when I frequently would only like a specific subset of data to be pivoted. An option to use a custom expression to filter the data prior to pivoting would ...

almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY