Custom Expressions

Add DataTable from existing plots of table types

Want to be able to add new datatables directly from the Statistics Table of Box Plot, Summarytable and Crosstable.

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

$esc() should also take strings as argument

Sometimes it would be useful when $esc() could use a string argument instead of a property. For example to set a display name using a condition, something like the foloowing expression: [Column] as $esc(if(${property}="1","1","not 1"))

over 8 years ago in Spotfire / Custom Expressions 0 Will not implement

1 VOTE

add function to update the value of document property

Please add function to update the value of document property from custome expression & calculated columns, it's very helpful in some use cases if we can assign value from data table to document property.

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

4 VOTE

Lastperiods() with negative period numbers

Hi, The lastperiods function can only accept positive first parameter (which indicates the number of periods to include in the calc (as opposed to the previousperiod function which can take negative arguments). if you tried to use this function in...

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

4 VOTE

Remove function overwrite in calculated columns and custom expressions

Currently if you type in an expression for a calculated column or a custom expression and then go back to the beginning of an expression and type another function, the original function gets overwritten. This is very annoying. I would like this fe...

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

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

2 VOTE

Make STRING_AGG available as aggregate function for In-Database connections

SAP HANA supports STRING_AGG function. https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/a924ee1e98ab435a874efa32e6f0ae14.html Also SQL Server and Azure Synapse support STRING_AGG https://docs.microsoft.com/en-us/sql/t-sql/...

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

almost 10 years ago in Spotfire / Custom Expressions 3 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 10 years ago in Spotfire / Custom Expressions 1 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 10 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY