Skip to main content
Hitachi VantaraPentaho Documentation
Pentaho Documentation

Using Conditional Formatting in Instaview

If you are not already, change to View mode by clicking View on the --check--Configure mode switch at the top of the interface.

Applying conditional formatting means that cells will be physically affected by the data they contain, and that formating depends on user-defined thresholds. Conditional formatting can help create relational contrast when you display your data.

These instructions explain how to implement data bars, a method of conditional cell formatting for numeric data. Conditional formatting with data bars draws a bar in each cell whose length corresponds to the value of the cell relative to the other cells in the selected range. If you have not already, switch the Analyzer Report to table format by clicking the Switch to table format button.

Switch to data bar format by right-clicking the Sales column, then select Conditional Formatting > Data Bar: Green-Yellow-Red from the sub-menu.

The table refreshes with green data bars within the cells of the Sales column, relative to the total amount of sales for the top-ten EMEA countries grouped by sales.

File:/instaview_using_conditional_formatting_result.png