How to Perform Calculations in Spotfire Cross Tables – Part 3

This is the third post in a three-part series related to calculations with a Cross Table visualization in TIBCO Spotfire. This one focuses on how to add interaction to a cross table calculation by dynamically updating the cross table. I’ll show you how to tie a drop-down list to a calculated column that’s used in a cross table calculation.

[ninja-popup ID=1995] CLICK HERE To download the Spotfire template shown in the video.[/ninja-popup]

Image 1- Cross Table with Drop Down List Inputs

If you haven’t yet, be sure to check out the other 2 posts here:

  1. How to Perform Calculations in Cross Tables – Part 1
  2. How to Perform Calculations in Cross Tables – Part 2

This post expands on the previous example. We’ll stick with the same calculated column method as described in that video, but add some flexibility and interaction by creating a drop-down list of values. There are 3 steps required to accomplish this:

  1. Insert a text area
  2. Add drop down lists (property controls) to the text area
  3. Tie the document property from the drop-down to the custom expression in the calculated column

Check out the video below for detailed explanation of each step.

If the embedded player above isn’t working, this video is also on YouTube: https://www.youtube.com/watch?v=U7mR2V9i-VI

If you’d like to learn more about document properties and controls, check out some of these other posts: http://www.datafuel.co/?s=property

Questions / Comments
I hope this has been a helpful demonstration of cross table calculations in Spotfire. If you have any questions or comments, or if there’s something you’d like featured on this blog, feel free to leave a comment below or email me at kyle@datafuel.co.

Leave a Reply

Your email address will not be published. Required fields are marked *