Custom Expressions

Showing 139

please add logical function any() / all()

please add logical function any() / all() to calculate any(true,false,false) => true any(fale,false,false) => false all(true,true,true) => true all(true,true,false) => false Currently we can sum them and compare to the count to do the ...

9 months ago in Spotfire / Custom Expressions 0 Future Consideration

3 VOTE

Create a 'List box' property control with expression within a text area using a table apart from the default table

While working in the Property control dialog, select the property and set 'Set property value through' to 'Expressions'. However, when you attempt to Edit the Expression, only the column names from the default table are visible but not other tables.

over 2 years ago in Spotfire / Custom Expressions 2 Future Consideration

7 VOTE

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...

over 5 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

12 VOTE

Change the data type of an existing property.

It's not available to change data type of property, once it registered. Please file an enhancement request to make it available. Note: From the help file: “The only thing you can change using Edit Property is …... If other settings are wrong, you ...

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

12 VOTE

Fiscal week method

The customer would like to be able to use fiscal week in addition to the other fiscal options

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

9 VOTE

Add YearAndMonth and Trunc Funtion

I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both toda...

over 7 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

11 VOTE

Import a list of tags

Create a list of tags from a table (based on values from a column) instead of raising tags one by one.

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

2 VOTE

Allow axis in a visualization to be used as a part of an OVER expression regardless of axis type

Currently, an axis has to be of type Categorical for it to be available in an Custom Expression with OVER() - e.g., [Axis.X] - in a given visualization. However, to add Line and Curves in the same visualization, the axis has to be Continuous. Enab...

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

7 VOTE

Random Sample data as Transformation option

Don't think this is currently possible. Currently, to do a random sample, I create a calculated column for random value like Rand(1). Then I filter the data to my sample size (e.g. I filter out 0.0 to 0.7 if I want a random sample that's 30% of th...

over 6 years ago in Spotfire / Custom Expressions 5 Future Consideration

10 VOTE

Data Table Description

I need the ability to add a detailed description of a data table in the Spotfire client. When I have multiple data tables in a complex analysis, it is easy to lose track of what purpose each data table serves. I experimented with adding a new Data...

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

Please enter your email address

FILTER BY CATEGORY