Custom Expressions

Showing 137

Not equal to should evaluate to true if value is null

User is stating that IF statements do not handle nulls as expected in calculated columns, or in limit data by expressions on a visualisation. Here is an example: 3 rows of data: ID Value1 Complete2 3 Not Complete Where in ID 2 , the value for the ...

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

6 VOTE

Control over formatting anywhere a custom expression is used

It is quite inconvenient that anywhere you use a custom expression you can't specify the format at the same time (or is there an undocumented keyword for expressions such as '[Home Runs]/[Runs] as [Percentage] like "#.# %"' ?)"

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

5 VOTE

Hide Repeating Hierarchy Levels

Flat ragged hierarchies often repeat values at lower levels due to different drill down paths. It would be very nice to have the options to hide levels if the parent has the same value. Currently I have to click down through many repeating levels ...

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

5 VOTE

Move the 'freeze Column' button away from the 'Edit' button for calculated fields

I can't tell you how many times I've accidentally clicked the Freeze Column button in an analysis. This causes the data table to become embedded, and there is no way to un-embed it. Thus I lose would, and because there's no version control in Spot...

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

over 3 years 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...

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

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

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

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

Please enter your email address

FILTER BY CATEGORY