Skip to content

Julie Sebby

Error Reporting with Alteryx & Spotfire

It’s a fact. If you have manual data entry, there will be errors. I found this out the hard way when working with our completions team on a Spotfire KPI project. We built the Spotfire KPIs and were attempting to tie out to spreadsheets. The numbers didn’t match. Discrepancies consistently traced back to bad data entry. We would fix the bad data, but without proper controls to keep it out, we were chasing our tails. So, we addressed bad data with a QAQC or error report. The first version was all Spotfire, but it had flaws. Version 2 performed error reporting with Alteryx. Ultimately, I wound up with a combination of Alteryx and Spotfire. To see what it looks like and how it was implemented, read on.

Read More »Error Reporting with Alteryx & Spotfire

How To Make Type Curve Inputs More Efficient

Type Curve generators are standard in reservoir engineering workflows. They are also a bit problematic. They require lots of inputs, which are time-consuming to build and fill out. You can’t easily recreate them in other projects. Therefore, my next two posts will show you how to make type curve inputs more efficient. The first post will demonstrate how to populate type curve inputs with IronPython and toggle between different sets of inputs. The second post will go further by allowing users to load type curve settings in a table. Then, the user tells an R function which row to pull from the table and place in the type curve inputs. Read on for these great solutions!

Read More »How To Make Type Curve Inputs More Efficient

How to Add Video to Spotfire Text Areas

The Spotfire projects I build just keep getting bigger and bigger. As they get bigger and more complex, it’s helpful to provide detailed instruction to users. One of the easiest ways to do that is with video. One of my coworkers recently showed me how he used basic HTML to embed a video tutorial for the analysis into a text area. Now, users don’t have to search for it. It’s right there in the DXP. This post will show you how to add a video to Spotfire text areas.

Read on to learn how.

Read More »How to Add Video to Spotfire Text Areas

How to Reset Marking When Changing Pages

  • Would you like to know how to reset marking when changing pages in an analysis?
  • Are you worried about users getting confused with markings on different pages and would like them to reset?
  • Are you using the same markings in multiple visualizations in an analysis?

If you answered yes to any of these questions, read on to find a simple solution that will reset all markings when a user moves to a different page.

Read More »How to Reset Marking When Changing Pages

How to Build Spotfire Data Connections for Multiple Users

This week’s post touches on a subject I’ve never written about before — data connections. More specifically, I’m going to explain how to build Spotfire data connections with a service account. Building data connections with a service account will allow you to create enterprise data connections that aren’t dependent on a single user’s credentials. Multiple users will be able to use data connections stored in the Spotfire library. If that catches your interest, read on.

Read More »How to Build Spotfire Data Connections for Multiple Users

Scheduling An Alteryx Workflow to Run On the Last Business Day of the Month

I haven’t written very much about Alteryx, although I do now use it EVERY SINGLE DAY. I’ve been hesitant because the Alt Nation Community is fabulous. I struggle with the utility of publishing my own content when it’s not likely to register in search results. However, I frequently write just for myself. And, it pays off. This week I referred back to a Spotfire post I wrote over 2 years ago. Therefore, I’m writing about a problem I ran into this week with scheduling an Alteryx workflow to run on the last business day of the month. If this is a problem you’ve run into, read on.

Read More »Scheduling An Alteryx Workflow to Run On the Last Business Day of the Month