cross tables – The Analytics Corner

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.