spotfire crosstable color by another column
I have one question about spotfire cross table using another column
I want to aggregate using column 'VALUE' but color by columns 'FLAG'.
I heard that this function was embedded in spotfire after version 11.2 https://community.tibco.com/s/article/What-s-New-in-TIBCO-Spotfire-11-2#colorcrosstablecellsbyothercolumns
Is there any idea implementing this problem?
Thanks!
table_A
table_B
Solution
Open the properties for the cross table and go to the color tab.
Check the 'Color the grouping using another expression'.
Specify the expression to color by in the field below the checkbox, see the attached image.
- Spotfire bar chart with variable amount of columns used for category axis
- On-demand loading in combination with modified SQL in information link
- How to update a label control in Spotfire with a matched data table column value when a drop-down filter control changes?
- Replace double quotes with blank space in Tibco Spotfire
- Earlier and Latest date of two columns
- Spotfire Table Visualization column width
- Spotfire- Scatterplot Line Connection Issue
- Spotfire and Regex- Extracting Several Values Stored in One Column
- How to find the consecutive values in a column based on another group column
- SpotFire - taking the average value over 90 days using only non zero values
- SpotFire - Sum up values over multiple Columns
- SpotFire - return data within two time intervals
- Spotfire and BigQuery
- How to Reload Individual Data Operations in TIBCO Spotfire Using IronPython Scripting
- Spotfire Date Ranks Incorrectly
- Adding multiple columns in a spotfire custom expression
- SytemError when trying to run progress bar when executing a script in spotfire
- Calculate the count of yes/no in multiple columns
- Difference between two row values within the same column based on value in third column in R
- Spotfire: DataFunctionError: Output variable was not defined
- Spotfire ironpython replacing data table values
- Compare two months from two different years in a bar chart
- Calculating daily average count of each category in Spotfire when some categories do not appear on every day
- How to get values from all the columns of the table in Spotfire using IronPython
- How to set a filtering scheme to data function input via ironpython?
- How can I draw a curve based on expression via ironpython?
- Why can I not cast my filter as listboxfilter in ironpython?
- How To Toggle Lines & Curves Names Visibility On Spotfire With Iron Python?
- Spotfire : Load already created pickle file from data function in spotfire
- calculate cumulative sale/production in calculated columns