Spotfire Ideas Portal
I have a table with column [serial_number] corresponding to list of equipment serial numbers. A 2nd column [condition] has value 1,2,3 for each serial numbers, which I successfully color as Green, Orange, Red. The problem is I do not want to show 1,2,3 in each cell, and I do _not_ want or need this column used in the table (just the color reference).
My question: Rather than show 1,2,3 in each cell, I want to show the serial_number in each cell , but colorize with color from [condtion]. in other words, is there a way to color a cell based on values from a different column?
Expressions for colors in cross tables?
| Implemented in | 11.2 |
Starting with Spotfire 11.2, you can now color cross table cells using another column or custom expression than the expression used for calculating the actual values that are displayed.
You can learn more about this in the What's New in Spotfire 11.2 page here: https://community.tibco.com/wiki/whats-new-tibco-spotfirer-112#toc-14
0
Implemented
Could we expand this functionality further to calculated values within graphical tables? If someone has already suggested this in the comments or elsewhere I apologize I just came across this today.
This is so important that i had no option but to use a very complicated work-around. I have to adjust the original values to round to 2 sig. digits then add 1.E3 or 1.E6 or 1.E9 to the original value (depending on the "other column value"). Then use this as this new value in my cross table/graphical table and in the color expression use Mod() to find if values exist in those significant digits that determine the color.
Very Complicated...
This is very important. I really miss this functionality.
Just a quick comment: For regular tables, this should already be possible. (At least for the data described in this idea entry, with both columns being numeric.) In a new table plot, create a new color scheme grouping containing both the serial_number and the condition columns, use fixed color mode, and then add three separate rules using boolean expressions ([condition] = 1 for green, [condition] = 2 for orange, etc). After adding all three rules, go to the Columns page and remove the condition column. The table plot will still show the serial_number column with the coloring specified.
Using Analyst Version 7.7. Really needed, coloring based on condition between two columns in Crosstab. All other tools have this basic feature. Straight implementation . IF colA > Col B, Color ColA 'Green', Else Default (something like this).
Any updated on this i still did not find this working in 10.4
It would also be useful to color rows according to the y axis labels. So if you have a category on the y-axis, the whole row can be colored accordingly.
was honestly in awe when I found out this wasn't possible. please please please do this
This is very important
This is an important conditinal formatting part as excel report have been moving to spotfire reports .
We need this feature ASAP. We would like to display the output performance of each production area comparing to each area's output target ( over target : green , below target : red ) . By implementing this, it will help us to achieve the entire factory output dashboard.
I also need this function !! please implement this ASAP !!
Individual cell color within a Cross table should be possibly configured by a separated column or a table.
I am looking at setting color only to one column instead of all columns. For example I have selected one column which has 'yes' and 'no' answers in it as horizontal axix. For cell values I have 2 columns - count and % of Total. I only want to color % Of total for 'No' answers. Currently it colors both 'Yes' and 'no' and this is not what I want
TK,
Thanks for the suggestion. I already do something similar and it works OK if you know what values will be in the data so you can use rules.
This doesn’t handle most of my cases where I can’t use rules.
I’m replying so the folks who rank priorities know there isn’t a work-around that works for these cases.
There is a hack available (it's pretty ugly, though) for those who really need this. Here's a link to the discussion about it: https://community.tibco.com/questions/cross-table-colors-cell-color-based-another-columns-value.
Basically, you use a custom expression in your cell values aggregations (under the Axes section of the cross table properties), and convert the totals to a string. You concatenate some special character (i like spaces on the right since they won't show up) based on a conditional of another column. Then you create a rule in the colors section looking for the character(s) - in my case just the right space(s).
I've still voted for this as the work-around isn't always useful and is a pain to implement. Hopefully it's a feature in Spotfire X.
This is one those missing features that cause users to copy/paste into Excel to get it how they want it.
This is a must have! In order to gain support for full refinery deployment of Spotfire, I need this feature! Otherwise IT is considering Power BI...
I was thinking about this today. It would be awesome if each column in a cross table had sub calculations like "Display this custom expression as the text in this cell", "calculate color based on this expression", "aggregate data based on this expression", "sort the values ascending based on this" etc.
Niklas, you have the power to make it so!
This would be very helpful in regular tables also.