My ideas: Custom Expressions

Showing 136

Concatenate for external data Oracle

I have connected to Oracla table using custom query and keeping data external. I would like to create a calculated column using Concatenate, but both concat([column1],[column2) and Concatenate([column1],[column2) are not accepted by the expression...

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

4 VOTE

For String columns in Data Panel, show counts for each unique category value

For number columns in data panel, a histogram is shown to visualize the data distribution. We also need a similar way to visualize the distribution of data for string columns. The way to do this is to visualize the counts for each unique category ...

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

1 VOTE

Remove comments from resulting expression

The resulting expression rendering box is very useful to me when debugging or creating custom expressions. It would be nice not to render the comments on my custom expression on the resulting expression box as shown here

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

4 VOTE

Select All/Deselect all options in Hierarchical Filter

"Hierarchy query devices by default use checkboxes. It would be very helpful to add Select All and Deselect all options for the checkboxes at each level of the hierarchy. For large hierarchies e.g. 3 levels of 10 nodes, it is quiet time consuming ...

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

4 VOTE

Filters should interact with each other even when data is external

Filters to influence eachother, and grey out filtered out values for other columns when filtering on any column, as it works when working with imported data. As a consumer and report developer I want the filters to behave the same when working wit...

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

3 VOTE

Built in conversion for Date strings in serial format

There doesn't seem to be any way for Spotfire to take a date string in serial format (41397) and convert it into a working date. I know when the data table is being uploaded, it can be registered as a date and will be converted. For the purpose of...

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

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

1 VOTE

Allowing for DateTimeNow() for UTC expression

Having analysts working in different time zones, it would be helpful to have an easier way to link data from different time zones and to use UTC when analyzing the data.

over 2 years ago in Spotfire / Custom Expressions 0 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 tha...

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

3 VOTE

Remove function overwrite in calculated columns and custom expressions

Currently if you type in an expression for a calculated column or a custom expression and then go back to the beginning of an expression and type another function, the original function gets overwritten. This is very annoying. I would like this fe...

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

Please enter your email address

FILTER BY CATEGORY