79681584

Date: 2025-06-27 07:53:59
Score: 1
Natty:
Report link

You can do this by using a colouring expression:

  1. Colour by (Cell Values)

  2. Check the box 'Colour the grouping using another expression'

  3. Add an expression, I got mine to work with this:

    case  when (
     First([Measure])="Measure 1") and (First([Facility])="Facility A") and (First([Value])>40) then "Green" when (
     First([Measure])="Measure 1") and (First([Facility])="Facility B") and (First([Value])>50) then "Green" when (
     First([Measure])="Measure 1") and (First([Facility])="Facility C") and (First([Value])>60) then "Green"
    else 
            "Red"
    end
    
  4. Select your desired colours below and voila:

    Spotfire cross table visualisation

Properties dialogue box for the cross table visualisation

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: John Munns