Month: June 2018

Using Spotfire Search Expressions to Limit Property Controls

Spotfire Property Controls like drop-down menus and list boxes can become cumbersome when a dataset has numerous variables and/or multiple data types.  What if we don’t want all columns to be available to the user for industry reasons (some columns wouldn’t make sense) or simply efficiency reasons (too many columns to sift through)?  What if only certain data types would be appropriate to use?  Fortunately, Spotfire lets us limit these list Property Controls via Search Expression.

Maybe you’ve seen those little search boxes in Spotfire which allow you to search for data (columns, categories, etc).  Maybe not, as I’m finding out even many Spotfire experts haven’t.  Search Expressions act distinctly from Custom Expressions.  These expressions do not use mathematical operations.  They do not use brackets to denote a column.  You cannot use another Document Property within the limiting expression.  These expressions serve only to search for strings using a simplified language (usually with the goal of selecting or limiting something).  Property Controls, Data Function Parameter windows, and the Information Designer are a few of the places you might find a Search Expression window and today’s discussion on Search Expressions will most likely apply to all of the scenarios.

So, let’s take a look at how we can use Search Expressions in different ways to control and limit the options in our list based Property Controls.

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.

Well Spacing: More Than One Number

With the rise of unconventionals and the increase in wells permeating already tapped fields, Well Spacing has become the hot topic du jour.  But, what is well spacing?  Does it refer simply to how many wells are in one area?  If so, is that area defined by a circle or rectangle or other definition?  What is the make-up of the nearby wells?  Today, we will examine some common terms and approaches to analyzing well spacing.

Two templates that utilize the features that we will discuss in today’s post are Well Spacing Feature Calculations and Horizontal Well Spacing Model.

Key terms we will discuss today:  Voronoi Diagram, circular and rectangular radius, Area of Interest, intersect area, intersecting wells, closest wells, closest distance, aggregated well statistics.

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.

Update to Troubleshooting Long Load Times

A few months ago, I authored this post on troubleshooting long load times.  There is now an even easier way to figure out which tables are slow loaders.  As of version 7.12, this information is available in the Help menu — Support Diagnostics and Logging.  Go to the Diagnostic Information tab and scroll down to the Application Information section.  The load time information will be at the bottom of that section.  It will tell you how long each table is taking to load.

 

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

MapReduce in MongoDB

Using MapReduce in MongoDB:

  • What are some benefits to MapReduce vs. Aggregation Pipelines
  • Parts of the mapReduce function.
  • How to create a mapReduce job.

 

Read More

Robert Henkhaus is the Product Manager and a Developer at Ruths.ai. He has 5 years of experience in the oil and gas industry and was previously with ConocoPhillips supporting BD and Land in high value decision spaces. Robert has a BS in Geography with emphasis in Earth Science from Texas A&M University. Before completing school, he also served 8 years in the Army as a sniper.

Comparing Dates in Spotfire Information Links

One of the first temptations in using an information link is to incorporate a Document Property that you set in the analysis. This allows the user to input a date, refresh the data, and receive a subset of the data. This is especially valuable when dealing with data sets with rows that number in the millions. These parameterized information links become very important and I wanted to share with you a quick “gotcha” in the process.

Read More

Technical Director at Ruths.ai

Rank Sorting a Spotfire Gantt Chart’s by the X-axis

Recently, a client reached out to see if I could help re-order the categorical Y-axis of their gantt chart by the numerical value on the X-axis. The client wanted the Y- axis ordered by the date of the first occurrence of an event. As the chart descended on the Y-Axis, the values would get larger on the X-axis. To do so took some trickery and an outsmarting of Spotfire–the methods which I will share here. Solving the problem left me with two learned lessons:

  1. How to re-order a Gantt Chart’s (or any Scatter Plot’s) categorical Y-axis by the value on the X-axis.
  2. Bonus trick: how to “white-out” an axis label so that it doesn’t show, while other labels remain.

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.