Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 146

Add EOMONTH (end of month) calculation function

EOMONTH() is a common Excel function because in many cases, users (all Oil & Gas industry) need to compute information based off the end of the month. Currently a typical user will not know how to compute the End of the Month using formulas be...
about 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

Allow for a linear regression to intercept ANY value in the Y axis

Sometimes you need for your linear regression to be forced through the origin or any value you want. This is a very old and standard feature available in Excel, which is important as an option when running linear regressions, that not necessarily ...
almost 6 years ago in Spotfire / Custom Expressions 1 Future Consideration

Override current culture when calculating week numbers

How week number are calculated in Spotfire depends on the current culture/locale settings in Windows. This means that the week number in Spotfire will be different on a US/English version of Windows than it would be on a Swedish version. I want to...
almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

Import data from multiple excel sheets at once into a single datatable

When an excel file with multiple files have to be imported, it will always allow to choose one sheet at a time to create a data table. Whereas what he / customer is looking for is to merge all the data from different sheets into one data table whe...
almost 9 years ago in Spotfire / Custom Expressions 2 Future Consideration

Enable Spotfire expression language for in-database connections

When working with external data one cannot use the standard Spotfire expressions but has to change to the dialect of the given data source (e.g. when working with an Impala connection a Left([Column_A],1) for imported data has to be changed to Sub...
about 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Additional string function where you are able to change the rounding settings

Belongs to the article https://community.tibco.com/questions/rounding-issue-string-function. If you use a numeric column and convert the result to a string column, there are always only 2 decimals shown. For calculating P values you´ll need 4 dec...
about 7 years ago in Spotfire / Custom Expressions / Data Management 6 Future Consideration

Add a Library Property option in addition to Column, Data Table, and Document Properties.

Frequently, I have information or a property that I want to share across all analyses in the library. These may contain expressions or variables to use for axis control, calculated columns, data limiting expressions etc. Rather than having to modi...
over 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

Add a way to update manually the calculated columns formula in case of embedded data table

Whenever I update the formula for a calculated columns in an embedded table, all formulas are refreshed until I can update other columns and it can take a long time with large data table (10 mio rows) and when you have multiple columns to update e...
almost 3 years ago in Spotfire / Custom Expressions 0 Future Consideration

Spotfire Analyst - Get the "Display Name" of expressions set from Property Control

When using a Property Control based on a drop-down selection, where the "Set property value through" = Expressions, there is no way currently to get the "Display Name" values. These values can be re-used in Custom Expressions for example. Thank yo...
almost 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Enable Insert Binned Column for In-Database

Binning is a very useful feature for dashboarding and also for ad hoc analysis and data discovery to add new categorization criteria. But currently Insert Binned Column dialog is not available for in-database connections. Instead users could use C...
over 6 years ago in Spotfire / Custom Expressions 2 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