Custom Expressions

Showing 137

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used

DateTimeNow Function in Limit Data Using Expression when in-database connection to SQL server is used is not available when Keep data external option is selected in connector. This limits the usage of Spotfire.

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

2 VOTE

Add support for quick calculations to Count/Unique e.g. cumulative sum based on count, difference based on counts

If you are working with a String column e.g. Product Name and you are looking at a unique count of product name by time, you can easily see how many unique products were sold e.g. per month. However, if you want to look at the cumulative unique pr...

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

1 VOTE

Can you please add SIGN function to the math functions?

No description provided

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

2 VOTE

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

Please enter your email address

FILTER BY CATEGORY