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 ...
Spotfire Analyst - Native conversion function for date in ISO 8601 format
There is no current built in function to convert a string containing a date in ISO 8601 format. Could TIBCO create this conversion function? This would avoid using substrings and DateTime. Thank you for your 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...
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...
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...
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...
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...
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...
