Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146

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

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

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

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

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

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

Add ability to reference already created values that are defined in a custom expression

Being able to reference already created values that are defined in a custom expression. For example you might use the below custom expression code. I will create an average voltage and standard deviation voltage variables for my typical process. I...
about 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

Allow OVER functions to access multiple aggregations and allow multiple OVERs per Custom Expression

Currently the OVER function is, frankly pretty poorly implemented for anyone wanting to do data analysis that's not time series data. OVER functions should be able to access aggregations in parenthesis. For example, if I wanted to calculate the av...
about 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

calculate over all periods of detail levels

Lets say we have a hierarchy of Year.Month, we want to calculate sum on all the same months (e.g. March) of each year. ParallelPeriod() can only calculate on the same month of previous year.
about 2 years ago in Spotfire / Custom Expressions 0 Future Consideration

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