custom expressions

How To Grab the File Extension of an Email Attachment

I’ve been working with email triggers a lot lately. Most of my use cases involve grabbing attachments from email and saving them on a shared drive. This is simple and easy to do, but….what you might not know about Power Automate is that it interprets any image in an email as an attachment. And, to avoid processing unnecessary files, the cloud flow should include a condition that looks at the file extension. So, how do you grab the file extension of an email attachment? It’s easy. Read on to find out.

Read More »How To Grab the File Extension of an Email Attachment

4 Functions to Simplify Date & Time in Power Automate

My most recent Power Automate builds have included a lot of work with date and time data. I thought this would be an excellent addition to the Getting Started with Power Automate series I started a few months ago. This is also a great starting place to learn about expressions. Read on to learn more about four functions that will help simplify working with date and time in Power Automate.

Read More »4 Functions to Simplify Date & Time in Power Automate

The Danger of Hiding Data in Spotfire

Occasionally, I have a really hard time coming up with a good title for a post. This is one of those circumstances. But what I’m going to show you here is important if you want to sharpen your troubleshooting skills. A user reached out to me this week for help with a calculation on a cross table. It seemed like Spotfire was calculating inconsistently, but software doesn’t work that way. So, we had to be missing something. Would you have figured this out? How quickly would you have solved this puzzle? Can you find data hiding in Spotfire? Read on to learn more.

Read More »The Danger of Hiding Data in Spotfire

Using Slider Property Controls in Spotfire Text Areas

This post concludes my series on learning how to use Spotfire property controls. Yay! We will end the series with a tutorial on how to use slider property controls in Spotfire text areas. This post will feature three use cases, two involving numbers and one with strings. Read on to learn more about using label property controls in Spotfire.

Read More »Using Slider Property Controls in Spotfire Text Areas

Using Label Property Controls in Spotfire

I am almost done with my series on learning how to use Spotfire property controls. We only have 2 controls left — labels and sliders. In this post, I’ll show you several different ways to use label property controls, and if you are registered for the TIBCO Analytics Forum, tune in to my breakout session for a look at using labels and IronPython scripts together. Read on to learn more about using label property controls in Spotfire.

Read More »Using Label Property Controls in Spotfire

How to Connect A Spotfire Display Name To A Property Control

Property controls make Spotfire analysis more flexible. However, the developer loses some control over the display name because Spotfire assumes the display name should equal the column name and the aggregation. So what do you do if you want to get rid of the aggregation and show only the column name? This post will show you how to connect a Spotfire display name to a property control without the aggregation for a clean and dynamic solution. Read on to learn more.

Read More »How to Connect A Spotfire Display Name To A Property Control

Using Input (multiple lines) Property Controls in Spotfire Text Areas

Welcome to week five of learning to use property controls. So far, I have covered drop-downs, list boxes, list box (multiple select), and input property controls. This week, I’ll cover input (multiple lines) property controls in Spotfire text areas. This particular property control performs well when users want to copy and paste identifiers (ex. well name, API, customer ID) and see only the data for those identifiers. Read on to learn more.

Read More »Using Input (multiple lines) Property Controls in Spotfire Text Areas

How to Use Input Property Controls in Spotfire Text Areas

Welcome to week four of learning to use property controls. So far, I have covered drop-downs, list boxes, and list box (multiple select). Today we cover two different ways to use input property controls. If you’re in oil and gas, input property controls will be your go-to for creating type curves in reservoir engineering workflows. Read on to learn more about creating input property controls in Spotfire text areas.

Read More »How to Use Input Property Controls in Spotfire Text Areas

How to Use List Box (multiple select) in Spotfire Text Areas

This is week three in my series on learning to use all of the Spotfire property controls. I started with drop-downs and list boxes. Today we hit list box (multiple select), which is really where we dig into the inner workings of custom expression syntax for property controls. Read on to learn how to use list box (multiple select) in Spotfire text areas.

Read More »How to Use List Box (multiple select) in Spotfire Text Areas