Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 144 of 4253

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( 'incre...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Have the same drilldown options for fiscal years as for calendar years

It would be great to be able to use the same date drilldown options in fiscal years as we can for calendar years, i.e. Fiscal Year > Fiscal Quarter > Month > DayOfMonth, and Fiscal Year > Month > DayOfMonth, or DayOfWeek. My com...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Need a function like the oracle NVL function

It is difficult handling null values when aggregating values within custom expressions because a single null values will cause the expression to evaluate as null. I (and others) often use logic like this: AggregationFunction( if([value] is no...
over 4 years ago in Spotfire / Custom Expressions 2 Already exists

Enable Spotfire expression language for in-database connections

When working with external data one cannot use the standard Spotfire expressions but has to change to the dialect of the given data source (e.g. when working with an Impala connection a Left([Column_A],1) for imported data has to be changed to Sub...
over 4 years ago in Spotfire / Custom Expressions 0 Future Consideration

Change the DateDiff function so that it returns int instead or real and doesn't return factional numbers

Currently, the DateDiff function factors in the fraction of the whole when returning the differences between year, quarter, month, etc. This can be confusing and hard to use when trying to calculate the differences between months as it will return...
almost 5 years ago in Spotfire / Custom Expressions 0 Will not implement

Coefficient of variation (%CV) function

I'd like to be able to calculate the %CV and select it as an aggregation option to plot values and select it as a statistical measures option in summary table form
almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Link Property Control to Expressions like in Calculated Values

There are numerous uses cases where being able to reference an expression against a data table would be useful as a property control. This could be used for doing a sum/min/max/uniqueconcatenate/etc for use in Visualization Titles, Lines & Cur...
about 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

A container for text area

I have a dynamic label and a calculated value whose values keep on changing based on my selection. The length of the label and the value dynamically change and they often end up out of position. Is there any way to link both them together so if po...
about 5 years ago in Spotfire / Custom Expressions 1 Future Consideration

Option to Auto update Data Relationship calculation when data is refreshed ...

Data relationship report in Spotfire 7.11.x (and earlier versions) does not automatically refresh (update) when the underlying data is updated! All what we get is the refresh icon on top of data relationship summary table. User has to manually hit...
about 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

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