Custom Expressions

Showing 144

$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 6 years ago in Spotfire / Custom Expressions 0 Will not implement

1 VOTE

Favorite registration and Export/Import functions for saving time to create same expression

I need favorite registration and Export/Import functions for saving time to create same expression. Often the same calculation new column is created and applied to several different analyses. In this case, the history function "Recent expressions"...

over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration

5 VOTE

Enhancement : "Insert column from external data” option doesn’t work when having 2 ondemand information link on same property control and column from one information link is inserted into another IL.

Enhancement : "Insert column from external data” option doesn’t work when having 2 ondemand information link on same property control and column from one information link is inserted into another IL. Problem description (Steps to reproduce): 1. Cr...

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

5 VOTE

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 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

1 VOTE

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...

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

1 VOTE

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...

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

1 VOTE

IFERROR Function

Adding a IFERROR function (similar to the one in Excel). This helps when analyzing data and prevent dividing by zero issue.

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

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

Please enter your email address

FILTER BY CATEGORY