Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 142

Make a Property's DisplayName usable in custom expressions

When using properties in custom expressions, one can only use the value of the property, not the DisplayName. This would be extremely useful to allow interaction with the DisplayName, particularly when using Expressions in Properties.
8 days ago in Spotfire / Custom Expressions 0 To be Reviewed

GUI interface for OVER expressions

OVER expressions are extremely powerful since they can achieve the same slicing and dicing of data which you can achieve using pivot transformations but in are more interactive way operating on subsets of data tables. At the same time most users w...
2 months ago in Spotfire / Custom Expressions 0 Future Consideration

should be telling us invalid part of the custom expression visually, not in writting

When an expression written in the custom expression is incorrect or when a function is invalid, an error is displayed with a red exclamation mark which telling us wrong part in writting, not visually. However it is not clear which part of the expr...
over 1 year ago in Spotfire / Custom Expressions 0 Future Consideration
102 VOTE

Save expressions /formulars in a central location in the library

In the section where you can insert calculated columns you can re-use previously used expressions. This is a handy feature. However, it shows all recent expressions. There is no option to include only the ones you want to be remembered. Hence Spot...
over 5 years ago in Spotfire / Custom Expressions 2 Future Consideration
146 VOTE

Use a Calculated value in a Property

There are at least three areas that I can currently create a calculated value. Text Areas Inputs for Data Function Graphical Tables However, if I want to have a Document Property to contain a calculated value, I can't do it without running some ...
about 8 years ago in Spotfire / Custom Expressions 12 Future Consideration
116 VOTE

Calculated Columns that Filter With Data

Calculated Columns are powerful but often not useful if they don't recalculated based on filtered data. We've developed scrips to flag filtered records and calculate over that flag but this requires the user to click a button every time they filte...
almost 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

Crosstable aggregate function for totals

I need to show the average of the row values in a cross table. The only option is a total as a sum, but what I really need is the average. In Tableau I could do this easy, when will Spotfire add this?
about 3 years ago in Spotfire / Custom Expressions 4 Future Consideration
105 VOTE

Reverse Sort order option for date columns

As a user, I want to be able to sort columns including various date formats in order to view data in chronological or reverse chronological order. Should support major date formats including: January 2012January 2 20122 January 20122012 January 21...
about 8 years ago in Spotfire / Custom Expressions 1 Future Consideration

Location invariant value formats in expressions

*Goal:*As an author, I need to control the exact format of my data so that I can properly configure the rest of my analysis. Regional language and cultural settings are client dependent and therefore dates and decimal separators change depending o...
about 8 years ago in Spotfire / Custom Expressions 2 Future Consideration

Makes the fields in the BinByDateTime() function dependent like YearAndWeek()

To meet the user calendar, the user needs to make registry as the following: iFirstWeekOfYear=2. And iFirstDayOfWeek=0. (Monday) Function BinByDateTime("1/1/2021 1:01:01 AM","Year.Week",1) will return this value: 2021.53 While using YearAndWeek(...
about 3 years ago in Spotfire / Custom Expressions 4 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