Coloring column based on column comparison - Spotfire Analyst 7.7

[SREEJAYAN cheri]

Hello all

Have a cross-tab with 8 columns. I need to compare one column AuthYoY and TotAuthYoY, and if AuthYoY > TotAuthYoY, need to color as 'green' or some color. Basically, a column by column comparison, for each row.

The cells values are formed in the expressiion in the Axes as:

Sum([Auth_Net_Frnt_CAD]) / Sum([Pre_Esr_Athrz_Net_Frnt_CAD])) - 1 as [AuthYoY]

Sum([Auth_Net_Frnt_CAD]) OVER (All([Axis.Rows])) / Sum([Pre_Esr_Athrz_Net_Frnt_CAD]) OVER (All([Axis.Rows]))) - 1 as [TotAuthYoY]

Selecting the color option doesn't provide me with the columns, but only Axis.Color.

Tried looking at the forums and searching, couldn't find anything, that I could pick up. Something like assigning the Axes columns to a Document.Property and doing an IF condition ...

Help appreciated. (If any of you have written similar code(ironPython or any expression), great if you could please share)

 

Thanks in advance

Cheri

[Khushboo Rabadia]

Unfortunately, you cannot achieve this in cross table. This is an enhancement request which you can vote for in ideas portal:

https://ideas.tibco.com/ideas/TS-I-5507

[Michael Kalada 2]

What about adding another column[TotAuthYoY]-[AuthYoY] and color that one

Im not seeing an option to color one column in a cross table baed on comparison to another column.

 

It looks like it's an enhancement request that has been "Under Consideration" since at least 2016

 

https://ideas.tibco.com/ideas/TS-I-5507

[Khushboo Rabadia]

Yes, you can color on one column i.e. A-B.  Then Add rule, if value <0 then red and >0 then green kind of.

[SREEJAYAN cheri]

Thanks all.  Need in cross table.  Other tools like SSRS, Tableau have these features and quite simple to implement.  

[Khushboo Rabadia]

Thanks cheri for feedback. Can you vote and add your concern/comments on this idea to get responses/updates from Product Management.

 

https://ideas.tibco.com/ideas/TS-I-5507