Custom Expressions

Showing 146

Add an aggregation method to find the Nth most common value

MostCommon is a pretty useful aggregation method, for example when you have a large set of defective parts across different products and these are defective for different reasons and you want to see the most prominent error say per product. Very e...

about 1 year ago in Spotfire / Custom Expressions 2 Future Consideration

8 VOTE

Have the same drilldown options for fiscal years as for calendar years

It would be great to be able to use the same date drilldown options in fiscal years as we can for calendar years, i.e. Fiscal Year > Fiscal Quarter > Month > DayOfMonth, and Fiscal Year > Month > DayOfMonth, or DayOfWeek. My compa...

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

9 VOTE

Output Holt-Winters forecast as calculated column

Just discovered the Holt-Winters forecasting implemtation in charts and find it extremely useful. However, it seems as if it was not possible to also get the forecasted values as a calculated column. This would be required to e.g. do some error co...

almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

9 VOTE

Integration of Seaborn, Plotly, Dash, Pandas,Numpy etc with Spotfire

There are various lib which we can use to ease data manipulation and visualization, it will add more value if integration is provided for such libraries.

almost 6 years ago in Spotfire / Custom Expressions 0 Future Consideration

13 VOTE

Ability to refer to filters in any custom expression

Goal: Currently custom expressions in calculated columns cannot refer to filtering schemes to find out whether a given row is filtered in or out. Also custom expressions in visualisations can only refer to their visualisation's filtering schema (...

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

7 VOTE

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column. Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6) Spotfire has a round function. But it would be gr...

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

6 VOTE

Differences between Preprocessor ($) and Document Property in custom expression

End user can insert a document property into an expression using the Insert Property option in the calculated column expression. This would add a preprocessor($) expression like ${documentproperty} When renaming a column name, the expression using...

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

9 VOTE

Add YearAndMonth and Trunc Funtion

I need a year/month combination constantly for calculations like "get data between two months ago 1st of the month to the end of next month" Having either or both of these functions would make this task much easier. Yes, I can accomplish both toda...

over 6 years ago in Spotfire / Custom Expressions / Data Management 1 Future Consideration

12 VOTE

Change the data type of an existing property.

It's not available to change data type of property, once it registered. Please file an enhancement request to make it available. Note: From the help file: “The only thing you can change using Edit Property is …... If other settings are wrong, you ...

almost 9 years ago in Spotfire / Custom Expressions 0 Future Consideration

11 VOTE

Import a list of tags

Create a list of tags from a table (based on values from a column) instead of raising tags one by one.

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

Please enter your email address

FILTER BY CATEGORY