Custom Expressions

Showing 137

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

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

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

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

1 VOTE

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

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

1 VOTE

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

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

1 VOTE

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.

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

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

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

Please enter your email address

FILTER BY CATEGORY