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({  'font-weight': 'bold',  'font-size': '10px',   'border': '2px solid black'});}

3. It is important to indicate the row number under 'e.rowIndex = x'. You can also do this for a column by changing 'rowIndex' to 'columnIndex'.

You can also paste the JavaScript into ChatGPT and ask it to change anything to what you need.

• Related Articles

• 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 | 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 ...

• FLOW Analytics | Set Up a Client/Supplier profile so they can log in and few their own data

  Some of our clients have started requesting that we provide their clients with logins to Flow Analytics so they can see their own data. This will be requested more going forward. I am going to use Zacpak from the Moosas environment to showcase how to ...

• 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 | Datatim Base Query 3 | Driver Masterfile Table

  The Driver Masterfile has a lot of unneccessary fields, but the Expiries dashboards are very popular, hence the detailed query below. SELECT DriverNumber, DriverName, TranspNo, TranspDescrip, DriverDormantFlag, PDPDate , LicenseDate , ...