FLOW Analytics | Highlight cell colours in Pivot Charts

A nice value-add to Pivot Charts is to colour certain rows or columns based on certain rules/measures.

Open the settings of the Pivot Chart and scroll down to Cell Customization:

The below will highlight each cell based on the below rules:

In order to highlight the cell colours based on a specific budget/goal/number, go to the Cell Customization and use the following Java Script:

if (e.area == 'data' && e.rowIndex == 1)
{if (e.cell.value < 0.075) {e.cellElement.css('background-color', 'rgba(193,39,45,0.4)');}
else if (e.cell.value >= 0.075 && e.cell.value <= 0.085) {e.cellElement.css('background-color', 'rgba(248, 219, 119, 1.0)');} else if (e.cell.value > 0.085) {e.cellElement.css('background-color', 'rgba(198, 239, 206, 1.0)');}}

What needs to change is the:
1. “e.rowIndex == [rownumber]”

2. “e.cell.value more or less than”

3. ‘rgba(colour)’ – you can ask ChatGPT for the rgba colour you are looking for – for example green/red/blue/etc.

The result of the above Cell Customization:
If the value is less than 7.5% (0.075), the colour is red;

If the value is between 7.5% (0.075) and 8.5% (0.085), the colour is orange;

If the value is more than 8.5% (0.085), the colour is green.

• Related Articles

• FLOW Analytics | Highlight the MIN and MAX on a Graph

  Some clients have requested that we highlight the MIN and MAX points on a graph to stand out. With the below JavaScript, we can accomplish this feat. 1. Having your explore open, navigate to the Advanced Settings on the Explore screen. 2. In the ...

• FLOW Analytics | Make cells Bold and Add a Border on a Pivot Chart

  You can format a cell to make it bold and add a border as well. 1. Go to Settings and into Cell Customization. 2. Copy and Paste the below JavaScript in the Cell Customization field: if (e.area == 'data' && e.rowIndex == 5) {e.cellElement.css({ ...

• FLOW Analytics | Datatim Base Query 7 | Vehicle Expense (VTRN) Table

  This is showing you ALL expense data. SELECT * FROM vwa_vtrn If you want Diesel Consumption, build a separate Data Model and have a look at the next article titled: FLOW Analytics | Datatim Base Query 8 | Diesel Consumption (VTRN) Table

• FLOW Analytics | Multiple Chart Types on 1 Explore

  A good feature of FLOW Analytics is combining different chart types onto 1 explore. The requirement is that you have 2 or more MEASURES and 1 Group. And then decide if they need to be on the same Y-Axis - i.e., are you measuring big numbers with each ...

• FLOW Analytics - Tooltip Customization

  Customizing the Tooltip on a graph helps with usability when it comes to larger numbers, for example viewing Revenue figures that stretches 7 or more digits. Copy Paste the following syntax into the Tooltip Customization box of the explore. You can ...