Custom Expressions

Showing 146

Change the DateDiff function so that it returns int instead or real and doesn't return factional numbers

Currently, the DateDiff function factors in the fraction of the whole when returning the differences between year, quarter, month, etc. This can be confusing and hard to use when trying to calculate the differences between months as it will return...

about 5 years ago in Spotfire / Custom Expressions 0 Will not implement

6 VOTE

Short Format Customization

Make all of the numbers in a column to be shown in the same short format. For example I have a number in the millions but I want it to show as 0.20Bn. I created a Short format saying 10^9 show billions but anything under a billion is showing the f...

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

5 VOTE

[Current Filtering] available in calculated column

Would be nice to be able to adjust a calculated column in an OVER expression using the current filtering

about 7 years ago in Spotfire / Custom Expressions 1 Will not implement

6 VOTE

Set Default Color For Categories

Frequently, there are specific colors that I want to use for certain dimensions in my data. For instance, if I have credit card transaction data, and I want to break things out by 'Card Type', I should be able to set "AmEx = Green", "Visa = Blue",...

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

6 VOTE

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

almost 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 "#.# %"' ?)"

almost 9 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/...

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

almost 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

4 VOTE

$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

Please enter your email address

FILTER BY CATEGORY