Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 137

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

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

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

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

display of common mathematical expressions based on highlighted data

Would like to highlight data on a graph, and have Spotfire tell me things like the Average, Mean, Max, Min without having to code. I should be able to Display or Hide the "Stats" window, and based on what I highlight in the graph, it calculates th...
over 6 years ago in Spotfire / Custom Expressions 1 Future Consideration

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

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

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

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) ...
over 2 years ago in Spotfire / Custom Expressions 1 Future Consideration

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...
over 2 years ago in Spotfire / Custom Expressions / User Experience 0 Future Consideration
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us