Data Highlighting

Highlighting helps you to better analyze data. Let’s prepare the table of the next structure:

On the rows – “Product Categories” dimension with a whole “Product” level selected under the “Touring Bikes” element:

on columns – years 2017 and 2018. Inside the table – “Reseller Sales Amount” measure.

Say, we need to emphasize somehow the sales amount larger than 500,000. To do that, perform one of the following actions:

• Select “Table / Highlight” from main menu.
• Select the corresponding item from the context menu of the table:

• Press the Highlight button at the bottom of the editor:

The window will appear containing highlight rules (there are no rules at the moment):

Press the Add button and a new tab with a highlight rule will appear.

Let’s name the rule “More than 500K” and fill in all the fields as it is shown on the picture below:

According to the configured rule, the “Reseller Sales Amount” measure will be analyzed. The type of analysis is Exception (exceptional situation), empty fields will be ignored and the values bigger than 500,000 will be colored green.

After pressing «OK» button you will see that all values bigger than 500,000 are highlighted with a green color:

You can set multiple highlight rules.

The highlight can also be of gradient type. Open the highlight rules window once again and change the highlight settings as it is shown on the picture:

After that the table will look like this:

You can easily notice that the bigger is value in the cell, the more saturated is its color. If you press the “Select” button in the highlight rule’s settings window,

then the other window will appear where you can set the gradient settings:

You can set one-color, two-color or rainbow highlight, set the number of steps, etc.