TIBCO Spotfire Community

Browse by Tags

• 3.1
• Binning
• Categories
• Color Axis
• Custom Expression
• DateDiff
• Expressions
• Freeze Columns
• Intersect
• Logical Comparison
• Node Navigation Methods
• OVER
• Pie Chart
• Properties
• ranking
• Script Controls
• Tags

• Adding Categories to your Data

  TIBCO Spotfire Professional provides a variety of ways to add categories into your data above those that are included in the raw data table. Four methods we will discuss are Columns from Calculations, Tagging, Columns from Binning, and Filter Out/To.... Posted Jun 20 2010, 03:52 PM by Tip of the Week Filed under: Calculated Columns, Tags, Categories, Binning

• Performing Logical Comparisons of Data

  There are times when you want to create a visualization that will show the relationship of various sets of data. Some of this can be done using a details visualizations, but it is also nice to be able to do this in a single visualization. For this, we... Posted May 02 2010, 07:22 AM by Tip of the Week Filed under: Custom Expression, Color Axis, Calculated Columns, Logical Comparison, Pie Chart

• Using Property Controls to Filter Data

  Property Controls are very useful for allowing consumers to affect values in an analysis file, like what to display on a given axis, but they do not work directly with marking or filtering. However, it is possible to hook property controls up to affect... Posted Apr 24 2010, 07:14 AM by Tip of the Week Filed under: Properties, Custom Expression, Calculated Columns, 3.1, Script Controls

• Retrieving values from one column to use in an expression in another Column

  A couple weeks ago we did a post that discussed how to rank something over various groups in their dataset. As a variation of this, many situations arise where customs need to find values in a specific column inside an expression available in another... Posted Feb 13 2010, 04:47 PM by Tip of the Week Filed under: Expressions, OVER, Calculated Columns

• Calculating Number of Business or Working Days

  One request that we get a lot is a way to calculate the difference between two dates, but only using business or working days (so not including the weekend). As with many of these types of solutions, we will need to create a new calculated column to hold... Posted Jan 23 2010, 07:32 PM by Tip of the Week Filed under: Calculated Columns, DateDiff

• Ranking Over Groups

  One common question we hear all the time in training is how a person can rank something over various groups in their dataset. The answer to this depends on your groups and how they are constructed. Ill explain by using two examples. First, let’s assume... Posted Jan 15 2010, 08:19 PM by Tip of the Week Filed under: Calculated Columns, ranking

• Using Node Navigation Methods in Calculated Columns

  People always ask us if there is a way to show changes in values from within the same column over different intervals, like weeks or months. For example, what was the sales this week compared to the sales last week, how much did a patient weight this... Posted Jan 03 2010, 05:09 PM by Tip of the Week Filed under: Expressions, Intersect, Calculated Columns, Node Navigation Methods

• Freezing Calculations

  Many customers create calculated columns to aide in their analysis. Calculated columns are static columns, but if the data in the underlying columns, which are used in the calculation, changes, it is recalculated based on the new data. However, TIBCO... Posted Oct 23 2009, 05:06 PM by Tip of the Week Filed under: Calculated Columns, Freeze Columns