Search code examples
spotfire

Spotfire - Graphical Table - Icons appearance based on some condition

I tried to use the Graphical table to show an icon in “RBG” color based on some conditions. In the screenshot1 (attached below) if the value shown in column 2 is less than 5, I want to show the icon next to it in RED otherwise in GREEN. But only one color icon is appearing. The reason is an ‘aggregation’ of data is automatically selected for the variable ‘FPDueDateDifference’ used in the condition (Please see screenshot 2 attached below. The ‘count’ aggregation is chosen by default.) . There is no “none” option available to choose and avoid the aggregation of data. Only if the aggregation is not chosen, i could add the custom expression "if [FPDueDateDifference] < 5, "RED","GREEN")". Based on the return value i would add the rules to display the icons in appropriate colour.

Please suggest some way to avoid this situation.

Screenshot 1: Screenshot1 shows the column 2 values and icon next to it Screenshot 2 shows the "count" aggregator is selected and "None" option not available

Solution

  • You must have an aggregation. A Graphical Table is similar to a Cross Table so you have categories, and the the aggregated values associated with these categories. You can still apply your logic though. After you set your value to count([FPDueDateDifference]) or if it suits you to use max() or first() what ever other aggregation, click "Add Rule" and then set up your logic like the below:

    Greater Than

    Then add another rule for Less Than or Equal To.