Custom Expressions

Showing 146

Empty values changed to zero in cross table should be used in over calculation

In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...

almost 8 years ago in Spotfire / Custom Expressions / Visualization 0 Future Consideration

2 VOTE

Create new "Tall" data table when using One-Click Unpivot

The One-Click Unpivot feature transforms data from the "wide" to the "tall" format. When it does so, it transforms the existing data table. On occasion, it is helpful to have both the original wide format as well as the new tall format. My request...

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

2 VOTE

Use expression spanning two tables with over expression for the main table.

1. Open SuperstoreSales 2. Add Data Tables -> SuperstoreSales again, call it T2. 3. Insert a barchart, use <[Order Priority]> on the x-axis 4. On the y-axis write: Sum([Sales Total]) OVER (AllPrevious([Axis.X])) - Sum([T2].[Sales Total]) ...

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

2 VOTE

Data functions should consider visual properties

Trellis by panel operation on data function execution results shows incorrect data in all split panels.This is an enhancement to support Data functions to any visual properties

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

2 VOTE

Expression Function in calculated column or in custom expression should work without any parameter value

Expression Function in calculated column or in custom expression always requires at least single parameter value to be passed. Steps to reproduce: - From Spotfire 7.0 Beta release , define new expression function(via the 'Data Function properties'...

almost 9 years ago in Spotfire / Analytics / Custom Expressions 2 Future Consideration

2 VOTE

Exclude Data Functions from executing during Scheduled Updates cache

*Goal:* As a administrator I want the option to exclude particular data functions from execution during Scheduled Updates since the data is personalized and the cached data is invalid and it will be executed again when the end user opens the repor...

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

1 VOTE

Automatic renaming of column names in expressions and transformations when replaced and matched with new columns name

Whenever we change that column name in the data source, we get the option to match the old column names against the new ones, but the column name does not change automatically in expressions and transformations. Our client has raised this request

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

1 VOTE

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

almost 5 years ago in Spotfire / Custom Expressions 2 Already exists

1 VOTE

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

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

1 VOTE

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

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

Please enter your email address

FILTER BY CATEGORY