Learning the Spotfire Expression Language

Why Do Counts Aggregate Differently in Spotfire?

by Julie Sebby
November 23, 2020December 10, 2020
Learning the Spotfire Expression Language, Spotfire, Visualizations

Last week, I wrote a post on using Axis Names on Cross Tables. My examples calculated the difference in Amounts between two scenarios on a cross table. I also needed to know the difference in well counts between scenarios, this time on a bar chart. But, when I changed the aggregation from a Sum to a CountDistinct, the calculations didn’t work anymore. That is because counts aggregate differently than the other aggregation methods. Read on if you want to get your counts right!

by Julie Sebby
November 17, 2020November 17, 2020
Learning the Spotfire Expression Language, Series, Spotfire
2 Comments

Okay, after a long hiatus, I’m restarting the series on learning axis names in all of the Spotfire visualizations. I’ll pick up where I left off with axis names on cross tables.

Troubleshooting Custom Expressions in Spotfire

by Julie Sebby
September 28, 2020September 21, 2020
Errors & Troubleshooting, Learning the Spotfire Expression Language, Spotfire
1 Comment

Working with custom expressions in Spotfire can be tricky. You try different combinations of syntax and just get errors. Sometimes the error message is helpful, but often it is just jibberish. How do you know exactly what’s getting passed thru the expression? There is a way to find out. Check out this short post for a solid pro-tip on troubleshooting custom expressions in Spotfire.

Spotfire Axis Names on Line Charts

by Julie Sebby
July 16, 2020July 16, 2020
Learning the Spotfire Expression Language, Series, Spotfire
4 Comments

If you’ve been following along, you know that my series on learning the Spotfire expression language is something of a long haul. It turns out that explaining Axis Names is a long and detailed affair. I am committed to it, and so this week I’m going thru axis names for line charts. If you missed it, check out Axis Names on Bar Charts.

Spotfire Axis Names on Bar Charts

by Julie Sebby
June 3, 2020June 3, 2020
Learning the Spotfire Expression Language, Series, Spotfire, Visualizations
8 Comments

Last week, I introduced the concept of Axis Names. If I counted correctly, there are 19 axis names applicable to one or more of the 14 visualizations in Spotfire. I will go through the axis names one visualization at a time, beginning with axis names on bar charts. Although, I learned very quickly that just because you can use an axis name on a given visualization, it doesn’t mean you should. I’ll show you what I mean by looking at Axis.X and Axis.Color. Read on to learn more.

What are Spotfire Axis Names?

by Julie Sebby
May 28, 2020May 28, 2020
Learning the Spotfire Expression Language, Series, Spotfire
8 Comments

A few months ago I started a series on Learning the Spotfire expression language. I covered the basics of calculations, keywords, node navigation, and a… Read More »What are Spotfire Axis Names?

$esc and $map Functions in Spotfire

by Julie Sebby
May 1, 2020May 28, 2020
Learning the Spotfire Expression Language, Series, Spotfire
7 Comments

A while ago, I started a series on learning the Spotfire expression language. I made a lot of progress on it but got pulled off on a few side quests. This week, I return to that theme with an explanation of how to use the $esc and $map functions in Spotfire. Knowing how to use these functions will allow you to connect visualizations to property control to provide a more interactive experience for users. It will also give you greater insight into how Spotfire expressions really work. Read on if you want to be able to…

Create dynamic visualizations that update with changes to property controls.
Use data limiting with property controls.

Master NavigatePeriod Node Navigation

by Julie Sebby
February 17, 2020May 28, 2020
Learning the Spotfire Expression Language, Series, Spotfire
5 Comments

This post will wrap up a lengthy discussion of Spotfire’s node navigation methods by explaining how to use NavigatePeriod. Now, you might have noticed, node… Read More »Master NavigatePeriod Node Navigation

Node Navigation – Parent & ParallelPeriod

by Julie Sebby
January 20, 2020May 28, 2020
Learning the Spotfire Expression Language, Series, Spotfire
1 Comment

This is post 9 in my series on how to learn the Spotfire expression language. It explains the Parent and ParallelPeriod node navigation methods. Originally, I included NavigatePeriod, but NavigatePeriod deserves its own post, so it will follow next week. Read on to learn about Parent and ParallelPeriod node navigation methods.

by Julie Sebby
January 13, 2020May 28, 2020
Learning the Spotfire Expression Language, Series, Spotfire
3 Comments

This is post 8 in my series on learning the Spotfire expression language. We are in the middle of exploring all of the node navigation methods. This post will cover FirstNode, LastNode, LastPeriods, PreviousPeriod and NextPeriod. I’m combining these particular methods in order to differentiate between Node, Period, and Periods. Read on to learn the difference.