Tag: custom expressions

Keeping Spotfire Visualizations Working when Replacing Data by Using Column Properties

Do you ever try to replace data in a Spotfire dxp only to find many of the visualizations no longer work?

At Ruths.ai, we create Spotfire templates as one of our main products.  Often, people have to replace our source data with their own to utilize our templates.  However, this can cause some complications when they match columns with different names than the ones in our source data.  Ideally, people would like to keep their column names because the names have business implications. Yet, when that column name has been hard coded into a Spotfire expression, a visualization, calculated column, or data limiting expression could break.

Until now.

In this post, we will demonstrate how to use column properties to ensure that expressions will remain intact in a Spotfire dxp even after changing a column name when replacing data.    

Read More

Jason is a Junior Data Scientist at Ruths.ai with a Master’s degree in Predictive Analytics and Data Science from Northwestern University. He has experience with a multitude of machine learning techniques such as Random Forest, Neural Nets, and Hidden Markov Models. With a previous Master’s in Creative Writing, Jason is a fervent believer in the Oxford comma.

Spotfire Expressions — how to return a column name from a property control rather than the column values and a Spotfire Description hack

  • Are you having issues using $esc with property controls in custom expressions?
  • Would you like to reference a column name in an expression but keep getting the column values instead?

Read More

Guest Spotfire blogger residing in Whitefish, MT.  Working for SM Energy’s Advanced Analytics and Emerging Technology team!

Where’s Waldo? – Using Logical and Text Functions to Find “_W”

When you’re performing column matching and the primary key of one table does not exactly match the similar column in the second table, data manipulation may be necessary. Using calculated columns, you could create the necessary values for column matching. This example demonstrates how to use a custom expression to extract a string of characters from a column when the number of character values may not be consistent.

Read More

Dashboard Feedback for Missing Packages using Inline TERR

Sometimes dashboards created in Spotfire 6.5 and above will require the use of R packages that are not native to the installation of TERR. While providing the user instructions on how to verify that R packages are installed, it can be helpful for the dashboard to be responsive and indicate missing packages.

Read More

Technical Director at Ruths.ai