Highlight in Table

Highlight in Table

The Highlight option is used for the conditional formatting of a widget. You can change the look and feel of the widget based on conditions that are configured.

The conditional formatting explained here highlights various data values present in table widgets like Table, Cross Table, and Sparkline Chart.

To use the Highlight option, first, we plot a Table using a dataset as shown below.



By default, the highlight formatting options do not appear in the same pane as they appear for other formatting options. They appear in a separate window where they are customized.

To add the highlight formatting conditions, follow the steps given below.

  1. Click Format to view the table formatting options.



    The various formatting options available for a table are displayed in the pane.
  2. Click Highlight, and then turn the Apply toggle button ON ().
    The Highlight page is displayed.
  3. Click Add Condition.



  4. Select the variable that you want to highlight from the Apply To drop-down.
  5. Select the mathematical condition from the If Value drop-down.



  6. Select Constant or Column from the drop-down depending upon the type of variable.

    Notes:

    • If you select a mathematical condition and Constant for which a value needs to be specified, enter the value in the field provided.
    • If you select a Column, then the adjoining field displays a Select Column drop-down. The drop-down lists all columns present in the Table. You can select any one of the columns.


  7. To select formatting styles, click the Formatting drop-down.

    The style options are displayed. You can select the

    • Font type, size, and color
    • Background color
    • Border color
    • Alignment of the highlighted value.

    You can also make the value bold, italic, or underline it.

    Note:

    You can highlight the entire row in Table and Sparkline Chart widget (containing the highlighted values), by selecting the Highlight Entire Row check box. However, this feature is not applicable to Cross Table widget.

  8. After selecting the style options of your choice, click Done.




    You can see the preview of the applied formatting style () in the Formatting field.

  9. Click Apply.



The dashboard page is displayed.

The formatting style gets applied to the value(s) in the Table as per the condition(s) added.

Here, in the plotted Table, the values >100 in the Cards column are displayed as shown in the figure given below.



Notes:

  • Using highlight conditional formatting, you can highlight,
    • All types of values (Numerical, Categorical, and Textual) in Table and Sparkline Chart widget.
    • Only Numerical values in Cross Table.
  • At any stage, you can clear the conditions and the applied formatting style by using Clear All.
  • You can abort the selection of highlight conditions and close the Highlight page by using Cancel.
  • If there are multiple conditions applied together, you can use the Drag Indicator icon () to change the sequence of the conditions by moving them up or down.
  • You can delete the applied highlight by using the Delete icon () on the Highlight page.

    • Related Articles

    • Highlight

      The Highlight option is used for conditional formatting of the chart. You can change the look and feel of the chart based on conditions that you can configure. This option is available for Line Chart, Bar Chart, Column Chart, and Area Chart. By ...

    • Table Style

      When you select a table style, you choose the way the table should appear. The table styles are explained in the table below. The table given below describes different fields present on Table Style formatting. Field Description Remark Style It ...

    • Formatting a Table

      You can format the tables that appear in various charts. Tabular data appears in the following widgets. Table Cross Table Sparkline Chart

    • Formatting a Table

      This formatting applies to widgets that contain tables. For example, table formatting is possible for widgets such as Table and Cross Table. To format the chart, follow the steps given below. Create the number of charts as required. Refer to Creating ...

    • Writing into Template Table

      You can store the result of algorithm flow or the Reader to a dataset table. Note: You can write to an RDBMS or ODBC (SQL, MySQL, PostgreSQL, or Oracle) datasets only. To write the output data to a template table, follow the steps given below. Build ...