Custom Expressions

Showing 146

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

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

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

10 VOTE

Fiscal week method

The customer would like to be able to use fiscal week in addition to the other fiscal options

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

2 VOTE

More methods to choose from regression modeling and classification modeling

I would like to use more methods to choose from regression modeling and classification modeling, e.g. Lasso. Also, Hyperparameter Optimization would be nice.

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

5 VOTE

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...

over 4 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

6 VOTE

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

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

over 8 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'...

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

2 VOTE

Create expressions from filter selections

Creating filter expressions for individual visualizations requires manual coding. Would like an option to include current filter selections in an expression so that non-technical business users can easily reduce the dimensions included in the visu...

about 2 years ago in Spotfire / Custom Expressions / Filters 0 Future Consideration

4 VOTE

Use List Document Property in SQL "IN" Statement within Custom Expressions

It would be useful to be able to pass a list type document property (e.g. "String List", "Date List", etc...) into a SQL "IN" statement in a custom expression or calculated column. This can then be used to provide input for options for consumer us...

about 4 years ago in Spotfire / Custom Expressions 3 Future Consideration

Please enter your email address

FILTER BY CATEGORY