Custom Expressions

Showing 139

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

3 VOTE

Show available functions for an In-Database Connection to SAP HANA

Functions like Case, If, All, AllPrevious Over etc. all work in Spotfire for in-database connection to SAP HANA. But they are not shown in the list of functions available. Our users need an easy to use interface without getting into details of wha...

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

3 VOTE

Refer to Marked items in a custom expression

The should be a way to refer to marked items in a custom expression. for example: sum(if([field1] in marking, 1, 0)) as [var1], sum(if([field1] not in marking, 1, 0)) as [var2] where marking is selected in a different visualization. I know that I ...

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

3 VOTE

Empty values changed to zero in cross table should be used in over calculation

In version 7.7 it is possible to change empty "---" values to 0 or some other value. When using over statement in cross table this values are not taken into account in calculation. For example, you would like to calculate the difference in sales b...

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

3 VOTE

Divide a Timespan with an Integer

When working in mobile data, we need to divide Communication time (timespan) with number of Call (Integer). Today the solution provide with conversion are far too complex for users.

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

1 VOTE

add function to convert integer to ascii character and vice versa

Please add function to convert integer to ascii character and vice versa. Currently we use expression like below to do so, it's ugly & slow and can not cover all ascii chars. case when ([val]>=48) and ([val]<=57) then string([val] - 48) ...

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

3 VOTE

Select data table from custom expression dialogue

When using multiple data tables and trying custom expression there is no way to manually select the data table from which to select the column. You can change the data table that is shown on the custom expression menu by going to Edit>Data tabl...

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

1 VOTE

Exclude Columns Transformation: Honor Exclusions Even When Data Type Changes

I want the exclude columns transformation to honor my request when I exclude column(s). I do not care if the data type changes. If I want the column excluded, then I do not want it in my data tables -- unless I specifically allow it. At the moment...

about 3 years ago in Spotfire / Custom Expressions / User Experience 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY