Author: Lucas Wood

Technical Director at Ruths.ai

How to Remove Title from DCA Wrangler

Lucas Wood Uncategorized Leave a comment

Right now there isn’t a way to take the title off the DCA Wrangler visualization. It takes up some space so it would be nice to tighten it up a bit. Here’s a quick IronPython script that will easily unflag the ShowTitle attribute:

Remember, once you write the script, you’ll still need to press OK to make it permanent and go through the whole process of creating a button. Only then can you delete the button and keep it the way you want. This procedure works for any custom visualization.

Finished product!

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

How to Pass Marked Data into a Document Property

Lucas Wood Spotfire Tricks Leave a comment

Consider this scenario, you have a calculation that necessitates the ability to pull a value from marked data. This is a complicated feedback system.

Setup the components

First, let’s setup the moving parts:

  • Create a document property ${sumMarkedRows}. This is going to be the document property that we’ll use in our calculation.
  • Created a text area. We need this so that our JavaScript can pass the data to the document property.
  • In the text area, add a Calculated value that is Sum([Column]).
  • Pick a marking layer that will facilitate this connection.

Connect the parts

Next we’ll need to pass that data from the marked layer to the calculated value to the JavaScript to the document property. What a mouthful!

  1. Create an input field for ${sumMarkedRows}
  2. Create a JavaScript that is called when the calculated value changes so we can pass it to the document property:

    <script>
    $(‘theIDoftheSpotfireCalcValue’).on(‘DOMSubtreeModified’,function(){
    $(‘theIDoftheInputfield’).text($(‘theIDoftheSpotfireCalcValue’).text());
    $(‘theIDoftheInputfield’).blur();
    })
    </script>

  3. That script needs the IDs swapped out then you can put it in the HTML area of that text area.
  4. Use ${sumMarkedRows} in your calculated column as the value that changes
  5. Wrap all of that with <div style=”display:none”>   …all the html…  </div> to hide that trickery
Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

How to Force Button Labels to Wrap in Spotfire

Lucas Wood Uncategorized 1 Comment

We had a quick question on how to wrap buttons in Spotfire. Usually buttons come out like this when you don’t specify the length of the button.

But! If you specify specific dimensions, you’ll find that your button label will trail off into the distance like the button below.

We can employ some simple tricks in Spotfire to get this label to wrap. You’ll need to have the ability to write CSS scripts using the <style> tag. Your Spotfire administrator can turn this on for you. To begin, you’ll need to do the following:

  1. Create a text area.
  2. Create your button with the size you want.
  3. Open the text area into the HTML editor by right-clicking and selecting Edit HTML…

In the script below, you’ll want to add the <style> tag that I have listed below

The white-space property controls how text wraps inside the button. You’ll override this property to the “normal” way it works. The “!important” attribute overrides how Spotfire does this.

Presto! You’re all set.

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

Using the Spotfire Application Profiler

Lucas Wood Uncategorized Leave a comment

Recently I needed to comb through the entire Exchange.ai library to see which templates had a certain set of Spotfire Extensions in them. This was a great application for Spotfire’ Application Profiler. Using the Application Profiler involves two IronPython scripts:

  • One where you define the output
  • One where you define the action you want to perform on each file.

Read More

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

How to insert a live Spotfire in a PowerPoint

Lucas Wood HTML, Spotfire, Spotfire Tricks 2 Comments

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

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

Comparing Dates in Spotfire Information Links

Lucas Wood Spotfire Leave a comment

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

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

Happy 100th Blog, Julie Schellberg/Sebby

Lucas Wood Thoughts Leave a comment

Just wanted to put up a shout out to Julie on her 100th blog. When we started DataShopTalk in Fall 2015, we had no idea how much traction and support we’d get from the community. DataShopTalk was always intended to fill the void of technical Spotfire/BI work in the oil and gas space and we are so surprised how well it’s done.

Especially from out contributors, among them Julie Schellberg now Sebby, started writing in August 2018, her first article was something about OVER commands. A consistently mysterious feature of Spotfire, Julie has tackled it and many others over the past two years.

This post is dedicated to Julie’s commitment to the Spotfire and BI community and we wish her happy writing and may her Spotfire never crash.

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

Updating your Exchange.ai Desktop

Lucas Wood Spotfire Leave a comment

If you having some trouble logging in, that’s a good problem! We’ve updated the Exchange.ai server for security and now you will need to log in using a new address. Follow along and we’ll get you set back up.

This is the first error you would have encountered; we’ll update the server name so that you can log in again. Press Manage Servers to update the server location.

Click Edit.

Change the server address to match above.

Once you login, you’ll update and then you should see this screen:

Congrats! You made it through.

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai

Turning Daily Data in Monthly

Lucas Wood Uncategorized 2 Comments

For the DCA Wrangler, you’ll need to have your data organization into monthly values, which is tricky if you have daily production data that you’re working with. The conversion, however, is simple in Spotfire. Follow these steps to convert daily to monthly:

  1. Select File > Add Data Tables…
  2. Select Source and choose your existing Daily production data from the current analysis

Before you press OK, we need to add some transformations:

  1. First, we need to Calculate new column, we need something to aggregate by and in this case it’s ProductionMonth. Use the expression: Date(Year([Date]),Month([Date]),1)
  2. Now add the Pivot:
    1. for your Row identifiers choose your newly created ProductionMonth.
    2. for your Value columns and aggregation methods select Sum(BOPD)
    3. set your Column naming pattern to %V
    4. if you have metadata to pass through such as well name or API add it to your Transfer columns and aggregation methods
  3. Review the data and press OK.

You’re all set! Repeat the process to include GAS or NGLs.

Best,
Lucas

Lucas Wood

Technical Director at Ruths.ai

http://ruths.ai