Why Do Counts Aggregate Differently in Spotfire?

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!

Read More »Why Do Counts Aggregate Differently in Spotfire?

Spotfire Prompts to Install Over and Over

This week, I ran into an issue with a user whose Spotfire desktop application kept prompting him to install the latest version of Spotfire (to match the latest version installed on the server). He would click install, and the installation would run. The next time Spotfire opened, the process would repeat itself. Fixing this isn’t a simple reinstall, but it is a relatively easy fix. Read on to learn how to solve this problem.

Read More »Spotfire Prompts to Install Over and Over

Data Limiting with Expression versus Show Hide

A few weeks ago, I wrote a post on data limiting in Spotfire when column names change. I provided solutions using both data limiting with expression and the Show Hide Items function. I struggled to get working solutions in both because I expected them to work the same way, but they do not. Therefore, this week, I developed a comprehensive tutorial to show you what they can do and how they are different. Read on to learn more.

Read More »Data Limiting with Expression versus Show Hide

Troubleshooting Custom Expressions in Spotfire

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.

Read More »Troubleshooting Custom Expressions in Spotfire

Limiting Data When Columns Change

This week I worked with one of our engineers on a Spotfire project where he needed to filter out nulls and zeros from his visualizations. This should be easy, but users set the y-axis columns using a property control. Basic data limiting by expression was impossible because the columns kept changing. Limiting data when columns change is challenging but not impossible. There are two ways to do it. Read on to learn more.

Read More »Limiting Data When Columns Change

Calculate the Last Value on a Visualization

Spotfire’s label functionality leaves a lot to be desired. You can turn on all labels, which will probably clutter the chart since you can’t move labels on most charts. Or, you can mark data points to see select labels. None of this is helpful if you want specific labels on an exported report, which is where I found myself last week. To get around Spotfire limitations and still fulfill my customer requirements, I opted to add a text area with a calculated value above my visualization. This allowed me to calculate the last value from a visualization without dealing with labels. My calculation was cumulative, so I expected that if I used the same calculation, the end result would be the last value on my visualization. It was not. Even TIBCO support was stumped as to why this didn’t work. Read on to learn a little bit more about calculated values and the Spotfire expression language.

Read More »Calculate the Last Value on a Visualization

How to Improve Spotfire Load Times

Long load times are a problem all Spotfire users struggle with eventually. The first step to reducing load time involves understanding which tables are taking the longest to load. Spotfire provides this information in the Help menu, but it’s not in a form that is easy to work with. This week, I need to help one of our project teams optimize their Spotfire project, so I built an Excel template to parse this data. Now I know what to go after in order to improve Spotfire load times.

Read More »How to Improve Spotfire Load Times

Use TERR to Dynamically Update Visualization Titles

This week, I worked with our production team to create a downtime dashboard. The dashboard only brings in allocated data, which has a two-day lag. It makes sense to include the date of the most recent data in the visualization title. This task can be accomplished with TERR, JavaScript, or Python. I chose TERR for my project, so this post will show you how to use TERR to dynamically update visualization titles.

Read More »Use TERR to Dynamically Update Visualization Titles