Custom Expressions

Showing 146

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(...

almost 4 years ago in Spotfire / Custom Expressions 4 Future Consideration

31 VOTE

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.

over 4 years ago in Spotfire / Custom Expressions 1 Future Consideration

16 VOTE

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

40 VOTE

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...

over 7 years ago in Spotfire / Custom Expressions 3 Future Consideration

14 VOTE

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...

almost 3 years ago in Spotfire / Custom Expressions 1 Future Consideration

15 VOTE

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

about 3 years ago in Spotfire / Custom Expressions 2 Future Consideration

3 VOTE

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 months ago in Spotfire / Custom Expressions 0 Future Consideration

2 VOTE

Add in the operator/function Between

SQL has a Between option. Spotfire could also benefit from a Between. We would use Between in case statements, if statements, or as standalone logic. Today we write: If([Data] >=1 and [Data] <= 2,true,false) This could be updated to be:If(Be...

5 months ago in Spotfire / Custom Expressions 0 Future Consideration

20 VOTE

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...

over 4 years ago in Spotfire / Custom Expressions 2 Future Consideration

20 VOTE

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...

over 5 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY