Last week, I kicked off a series on learning how to use the Spotfire expression language. The first post explained the 2 different ways to create calculations in Spotfire. This week, I’m going to talk about the over keyword and how to use it. Without the over keyword, it’s impossible to really get into the Spotfire expression language. It’s also a good starting point for learning node navigation. Read on to learn more.
Read More »Use the Over Keyword
I recently kicked off a series on learning how to use the Spotfire expression language. The first post explained different ways to create calculations in Spotfire. Next week, I’ll release a post on how to use the over keyword. Axis names are a more advanced topic, which technically puts it a bit “out of order”. But, axis names are what inspired me to write the series, and I know that if I don’t write about something when I am working it, I often never get to it. Thus, I am going to show you how to use axis names in Spotfire cross tables.
Read More »How to Use Axis Names in Spotfire Cross TablesSince launching the Analytics Corner, I’ve focused heavily on IronPython with a dash of Alteryx. I’ve started working more with Axis Names recently, which was a reminder of how nonintuitive they are. Because I haven’t written much on Spotfire expressions since starting the Analytics Corner, I’m going to do a comprehensive series on how to learn the Spotfire expression language, which will include a good section on Axis Names.
Today’s first post will be a short summary of the different ways to write expressions in Spotfire. Next week, I’ll talk about the over keyword. Then, I’ll cover node navigation, which might take more than one post. I will also show you how to use important functions like $esc and $map. Finally, I’ll close out with a few posts on Axis Names. Read on to get started.
Read More »How to Learn the Spotfire Expression Language
A coworker reached out to me for help on a visualization. He was using a drop-down property control to set the value of a bar chart x-axis. If he chooses option 1 or option 2, the display name should be a certain value. If he chooses option 3 or option 4, a different value should appear. I’ve definitely had this come up before when using dropdown property controls. There is an IronPython solution for creating dynamic display names. Let me show you.
Read More »Creating Dynamic Display Names for Spotfire Visualizations
Regular readers know I am doing a lot of work in Alteryx these days. Actually, our entire analytics team is. We collaborate a lot on… Read More »Calculate Working Days Between Two Dates in Spotfire and Alteryx
This week, I worked on a dashboard where the user requested a snapshot of yesterday’s operational activities. The dashboard itself was simple enough, a single… Read More »Use Spotfire Date and Time Functions to Create a Dashboard
Welcome to part 5 of my Spotfire Data Limiting Series. The first post in the series covered data limiting with the filter and data panels. The second post talked about data limiting in the web player. The third post discussed limiting using filtering schemes. Last week, I covered limiting with marking. Now, we are on to limiting with expressions. As a new Spotfire user, I was enamored with filtering schemes, but as my skills developed, limiting with marking became my go-to method.
Read More »Data Limiting With Expressions