Custom Expressions

Showing 143

Self joins to calculate changes

Hi, I need help with this in Tibco Spotfire 7.6 I have columns [Name] [Manager] [Director] [Date] Rahul Rohit Ravi Jan-18 John Jessica Parul Jan-18 Tj Manu Raghav Feb-18 Rahul Rohit Rashid Feb-18 John Jessica Parul Feb-18 I want to dis...

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

1 VOTE

Enable text funtions for custom expressions

I am having a filter that has a long name. E.g. 'Performance Yaw'. This is to distinguish for the users between 2 types of analysis, e.g. Performance or Reliability. Now I am trying to use it in a custom expression where I want to use always the...

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

1 VOTE

Cross table formatting of Timespan

In cross table a column that is formatted as h:m:s gives the correct grand total. However the same column if formatted as hh:mm:ss, the behavior changes and Spotfire resets the hours to 0 after every 24 hours and gives a different grand total. Exa...

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

1 VOTE

allow to view and select unique data values of selected column when writing expression.

sometimes, when we are writing an expression, we used the values of the column so if it can be autocompleted or displayed unique values and let the user copy it, it will be very useful. for example: [Country] != "Egypt", if I select column [coun...

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

1 VOTE

Adding Fiscal date hierarchy

Hi, All our analysis is based on Fiscal calendar. To get this filter I need to create three separate columns (one each for year, quarter, month) and combine them as hierarchy hence creating unnecessary data columns and too much of work as we have...

over 6 years ago in Spotfire / Custom Expressions 1 Already exists

1 VOTE

Sum in a custom expression using Intersect

Currently Max in a custom expression using intersect will work properly. Sum does not. This would be beneficial for things like dynamically calculating error rates based on user selections. I.e. aggregating variances at any level and summing those...

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

1 VOTE

Issue in getting the total count across the points

Hi, We are trying to get the total count of the failures across the map grids on map chart. Count of the failures in grids is achievable but inorder to compute the percentage of failures , the total count is required. There is no way to compute th...

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

1 VOTE

Multiple expression columns in property controls.

While it is possible to plug an expression into a plot axis with a document property, often it is necessary to plug that calculation into two visualizations. The difficulty is that two (or more) expressions are required because of the visualizatio...

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

1 VOTE

Text Function - Calculated column - InitCap String Function

Objective to make the string init caps. Eg. Alpha We have a workaround where we can take the 1st character of the string and make it upper then append it it would be great, if we have in built function making first char of a string upper and o...

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

1 VOTE

Add expression function to convert Temperature

This is one of those simple things that you'd think would be in the tool already, but just isn't. Here's an example of how it's implemented in Excel. I would use the exact same approach. https://www.extendoffice.com/documents/excel/1254-excel-co...

about 8 years ago in Spotfire / Custom Expressions 0 Future Consideration

Please enter your email address

FILTER BY CATEGORY