Month: July 2018

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 Malware Flag

Normally, I lead off with questions intending to help the user decipher whether the post is relevant to them.  In this case, the questions I came up with were almost too comical to take seriously.  Here they are anyway….

  • Are you suspicious that Spotfire is attacking your computer?
  • Has your company’s security team flagged Spotfire temp files?
  • Are you worried malware has been installed on your computer veiled as Spotfire files?

Read More

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

“Whiting Out” a Visualization Label in Spotfire

When using Spotfire, do you ever place a variable on an axis to make the visualization look a certain way, only to see its label show up unwanted next to the other necessary labels?

I’ve had this happen when manipulating dates or forcing a visualization (scatter plot, waterfall chart, bar chart) to be in a certain rank order.  Recently, I wrote a post on how to rank and order a gantt chart, which faced this issue.  I discussed how to remedy the issue in that article, but here I want to highlight the method used since we can use it in many other scenarios.

In this post, we will discuss how to white out a label on an axis.

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.

Writing Calculations Against Untagged Records

  • Would you like to know how to use tags and tag collections?
  • Are you using tags and tag collections to create custom groupings?
  • Did you know creating a tag collection creates a new column of data in the table?
  • Would you like to flag records in a table that are Untagged?

Read More

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

Exporting Spotfire to PDF with Action Control Button

Recent Spotfire versions include the ability to export visualizations, pages, or the entire analysis into a PDF from the File menu or even with an Action Control button.  Finally!  Version 7.12 includes extremely user friendly customization options while previous versions require some IronPython code:  we will address both here.

The 7.12 version gives the user an interface for customization that we could previously only access via IronPython.  Spotfire has delivered what many users for years have clamored for, so check it out after the break…

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.

How to insert a live Spotfire in a PowerPoint

I’m embarrassed to say that I have telling people this wasn’t possible for the longest time but turns out, the Office Add-ins store had a plugin for HTML code in PowerPoint.

Setting up the Add-on

Go into PowerPoint, and from the top select Store. This opens the Office Add-ins for PowerPoint:

Search for HTML and select Office Apps Fiddle for PowerPoint.

Adding the script

Drop in your new add-in and select HTML.

Use the code listed here and replace it with the link to your Spotfire file. Serious caveat: You will need to log into the server every time, but that can simply be prep for your meeting.

Finished! The web player will be interactive inside the PowerPoint and works great. This presentation will stay current with your live data.

For some further improvements, you can use JavaScript mashup to integrate it a little better.

Regards,

Lucas

Technical Director at Ruths.ai

Spotfire: Utilizing Column Properties (and How to Make Your Own)

Did you know that you can create your own Column Property and then designate a property value for each column?  Did you know that you can do this not only in the Property Control window but also in the Column Property window for even more flexibility?

Why might you want to create your own Column Property?  Maybe you want to group a handful of columns together by some shared quality.  Why might you want to do that?  Both Custom Expressions and Search Expressions can utilize a Column Property, so you can create these properties for columns and then reference the columns with a shared quality.

Frankly, there is a lot of uncharted territory and potential innovation within this relatively unknown Spotfire feature, so our main focus today will be to discuss briefly what Column Properties are, demonstrate two ways to make your own, and show one possible use case.

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.

More on Column Name Search

  • Would you like to search for column names based on part of the column name?
  • Have you ever wanted to search for column names based on more than one criteria?
  • Did you enjoy the last two posts on searching and limiting columns in data functions and property controls?

Read More

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