Custom Expressions

Showing 143

Improve Lag/Lead Functions

Now implemented but documentation doesn't specify how the ordering of rows is important; in addition, the ordering of rows is not guaranteed, so the functions are not trustworthy at present

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

4 VOTE

Allow the creation and definition of some enterprise document properties

Many reports can draw on the same document definitions that need to be recreated in each new analysis, or a template is required to predefine them. There is already on e enterprise document property "Financial Offset". Similarly, it would be conve...

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

4 VOTE

Date diff function excluding weekends (Working days)

DateDiff - function is used to find the ageing between start date and end date but it includes weekends. Spotfire should add a new functionality in DateDiff function which accepts are parameter to exclude weekends and find working days ageing. D...

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

1 VOTE

Concatenate for external data Oracle

I have connected to Oracla table using custom query and keeping data external. I would like to create a calculated column using Concatenate, but both concat([column1],[column2) and Concatenate([column1],[column2) are not accepted by the expression...

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

3 VOTE

display of common mathematical expressions based on highlighted data

Would like to highlight data on a graph, and have Spotfire tell me things like the Average, Mean, Max, Min without having to code. I should be able to Display or Hide the "Stats" window, and based on what I highlight in the graph, it calculates th...

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

4 VOTE

For String columns in Data Panel, show counts for each unique category value

For number columns in data panel, a histogram is shown to visualize the data distribution. We also need a similar way to visualize the distribution of data for string columns. The way to do this is to visualize the counts for each unique category ...

about 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

2 VOTE

Better decimal point accuracy on color rule for column created through a custom expression

I have created a percentage value as part of a custom expression - and within the Formatting menu, this field has been setup as a "Percentage". When I create a new color rule using this column, it allows me to enter decimal based values into the r...

about 4 years ago in Spotfire / Custom Expressions 2 Already exists

1 VOTE

Remove comments from resulting expression

The resulting expression rendering box is very useful to me when debugging or creating custom expressions. It would be nice not to render the comments on my custom expression on the resulting expression box as shown here

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

4 VOTE

Select All/Deselect all options in Hierarchical Filter

"Hierarchy query devices by default use checkboxes. It would be very helpful to add Select All and Deselect all options for the checkboxes at each level of the hierarchy. For large hierarchies e.g. 3 levels of 10 nodes, it is quiet time consuming ...

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

4 VOTE

Filters should interact with each other even when data is external

Filters to influence eachother, and grey out filtered out values for other columns when filtering on any column, as it works when working with imported data. As a consumer and report developer I want the filters to behave the same when working wit...

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

Please enter your email address

FILTER BY CATEGORY