make a staggered layout in Spotfire. that changes from being 3 columns to 1

[Manuela Osorio]

Hello!

I need to create a graph in Spotfire that allows me to have those fields that are in 3 columns, in one column. But that must comply with the fact that the first and the last are in bold (or has a different color), something like this:

 

If I try it in a Cross table placing COLUMN_1, COLUMN_2, and COLUMN_3 in the vertical Axes I get the following result

 

And if I try with a graphical table putting the three columns as a Row, the result is a bit close to what I expected but it still doesn't work

 

Does anyone know if there is a way to do this? I would appreciate it if you can help me.

[Julieta Diaz]

Hi Manuela,

I have looked at your question and I suggest using the "Unpivot" transformation as in the screenshot above. Please let us know if it works. Regards.

[Julieta Diaz]

• In order to have a space you can create a fourth column (column4) that contains a space, before unpivoting all four columns.
• To create the colours, you can apply a boolean expression to the colour of Value like this (colour applied to the text). The result is on the second screenshot.