That TOP SECRET Trick

Suppose this month you had an analysis that takes some input parameters (ABC) and runs some logic to generate a results table (XYZ).  Next month comes along and you want to look-back at these results and perhaps compare the values to last month. You realize that the data in the .dxp you’re using is linked to source and when you opened this .dxp all of the values are updated with no way for you to view what the values were previously.

BUMMER.

But wait. There’s hope! This secret I’m about to share with you will demonstrate how to generate a third table that will store values from columns you specify with a “scenario” value you input. Can you think of other reasons why knowing this TOP SECRET trick might be useful in your day-to-day?

Read More

Spotfire Data Functions — TERR Basics

  • Have you experienced difficulty trying to implement data functions or TERR code from blog posts?
  • Do you find that blog post frequently assume you know how data functions work and simple but important steps are missing?
  • Can you follow blog post steps but don’t know why a step is required and thus can’t implement it in a different scenario?
  • Do you feel like you are lacking in a foundational or basic understanding of how TERR works in Spotfire?

Read More

Guest Blog: Worm Charts

Harsh Budhiraja is a process engineer/metallurgist in Australia using Spotfire for real-time data processing and decision making. We are happy to feature him on datashoptalk as a guest blogger!

Worm Charts or (Actual vs Target Charts) are useful in a production environment where you want to see the cumulative production against planned production for a certain period. In Excel, they are easy where you have more control over things at Row level. But since the requirement was for the user to update it with date inputs, they had to be built in Spotfire with all the database connections.

See this example:

Read More

Why can’t I move my visualization?

The Title Bar must be visible [on] to rearrange a visualization within the same page or to move the visualization to another tab. The Title Bar is what is used to grab the visualization using the left mouse button. There are several ways to activate the Title Bar.

By default, when creating a new visualization, the Title Bar is on. However, often we use a Spotfire Template or someone else’s project or simply forgot we set the Title Bar off. Activating the Title Bar is different depending if we have a Text Area versus a Table or Graphical Visualization. In the figure below the Title Bar is on for the Pie Chart but off for the Text Area, see highlighted areas. Note, mouse must be moved to these areas to see if Title Bar is on or off.

To turn on the Title Bar in the Text Area we right mouse click in the Text Area > Properties > check “Show title bar.” If we wanted to add / remove Title Bar in a Table or Graphical visualization, we right mouse click in white space next to our graphical visualization (or inside Table visualization) > Properties > Visualization Features > check “Title Bar,” as in second figure below.

Finally, the Title Bar can be activated from any visualization under Properties > General.