Defining Column Attributes

There are three types of columns you can create when you click the Add Column Button in the Table Editor i.e. Statistic, Keyword and Formula columns. In each case you can name the column, define it as a control value, hide it from the finished table and format the output according to criteria of your choice. These functions are the same for Statistic, Keyword and Formula columns. Here they are explained using the Keyword definition page.

In the Custom name (column heading): box you can create a name for the column when it appears in the finished table, or override the name it was given by default in the Table Editor.

Check the Define as a contol value... box if you do NOT wish this column to be batched when the table is created.

Check Hide this column in output table to perform any indicated calculation using the column but to prevent this column being displayed in the final table.

Special Formatting You may want to highlight certain results when you create a table. FlowJo lets you change the formatting of table values based on their relationship to standard deviation or a numerical value. Choose your criteria on the left, and values that satisfy them will be formatted according to your selections on the right. By default, FlowJo's tables will make 2>SD>1 values bold, red and italic, and SD>1 values bold and black.

Values in the current column will be checked against the criteria you list here, in the order that you list them. As soon as a criterion is satisfied, the corresponding formatting is applied and the next value in the column is examined.

The first drop-down menu under Special Formatting offers the choices below left.

The second drop-down menu offers the choices above right.

Example: “I want to add a ratio of my CD4/CD8 values to the table. If the ratio is >2, I want the values in my table to be green. If the ratio is <2, I want the values to be red.“Set up the tool this way:

Click the OK button. In the Table Editor, click the Create Table button. If the ratio is >2, the values in the table will be bold and green. If the ratio is <2, the values in the table will be bold and red.

To change the characteristics of the column you have defined click on the Column Info button in the Table Editor.