I have a cross table that I want to color the cells based on the value of the previous column.

[Mark Manalo]

Say for the cross table below:

The boolean expression, Last([Axis.Color]) over Previous([Axis.Color]) = 17, is not working as I expected. I am expecting that using this expression with change the cell color for Aug2022 and Oct2022.

[Gaia Paolini]

I cannot work out how you got to that expression. Could you upload a sample dxp?

[Mark Manalo]

Hi Gaia, attached is the sample dxp file.

[Gaia Paolini]

The way you were trying, you only had Axis.Color to work with, and Axis.Color is not a number so it did not work.

I tried a few options, the only one that worked was to add two calculated columns: a [Month] as Month([DATE_TIME]), and a previous month average [Prev_month_avg] as Avg([CYCLE_TIME]) over (Previous([Month])). I could not put the Month expression directly in the second column, as OVER does not work with expressions.

Then you can colour by the latter in your cross table. Instead of the Boolean expression, choose the option of Color the grouping using another expression. Note you need to have TEST selected in order to see the colours (for some reason it always reverts to focus on the Numeric grouping when you open it first).

I am attaching the dxp.

[Mark Manalo]

Is  Color the grouping using another expression available only for version 12? We are using version 10.

[Gaia Paolini]

You're right, the option was introduced in 11.2. Are you able to upgrade your version?

https://community.spotfire.com/s/article/What-s-New-in-TIBCO-Spotfire-11-2#colorcrosstablecellsbyothercolumns