Spotfire Ideas Portal
ADD A NEW IDEA

Custom Expressions

Showing 137

please add logical function any() / all()

please add logical function any() / all() to calculate any(true,false,false) => true any(fale,false,false) => false all(true,true,true) => true all(true,true,false) => false Currently we can sum them and compare to the count to do the ...
2 months ago in Spotfire / Custom Expressions 0 Future Consideration

Add an apply changes button to Custom Expression dialogue box

I do a lot of cross tables and other visualizations with lots of 'Columns' that are custom expressions, and often I have to go through them and make changes to one or more than one of the expressions. It would be really helpful to have a button in...
over 2 years ago in Spotfire / Custom Expressions / User Experience 1 Future Consideration

Way to calculate number of working week day

We're looking for a simple way to calculate the number of working weekdays. In Spotfire, there is no simple function, but in Tableau, there is a "Weekday"DateDiff("weekday",[ORDER DATE],[DELIVERY DATE])In Spotfire, the closest I got is this refere...
almost 8 years ago in Spotfire / Custom Expressions 3 Future Consideration

To have offset in DayofWeek similar to FiscalYear

Week day is different in GCC countries hence it will be great if we have offset option in DayofWeek function
over 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

IN function like the IN operator in SQL

Ability to filter/limit data data like '[column] IN (value1, value2, ...)' this would result in a more readable construction then [column] = 'value1' and [column] = 'value2'. Work around is the to use the regular expression but that is harder if v...
about 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

Insert custom expression into title of visual

At the moment, it is possible to insert Dynamic Item with Calculated value into Text area. In this way you can visualize the value of arbitrary custom expression in text area. I am suggesting to have same dynamic option in the graph tittle. Usecas...
about 5 years ago in Spotfire / Custom Expressions 2 Future Consideration

Option to Auto update Data Relationship calculation when data is refreshed ...

Data relationship report in Spotfire 7.11.x (and earlier versions) does not automatically refresh (update) when the underlying data is updated! All what we get is the refresh icon on top of data relationship summary table. User has to manually hit...
almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

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