Byos reports can be customized by the addition of pre- or post-pivot dynamic columns, which are JavaScript based. Pre-pivot JavaScript code changes the flat input table either for the whole report or for a single specific tab. The changes include the addition of one or multiple new columns, or the manipulation of existing ones. Post-pivot JavaScript code, on the other hand, manipulates the pivot table of the selected tab. To add or to update existing code, complete the following steps:
-
Go to Edit → Edit dynamic columns and select one option:
-
To add an new column click “Add new column”, enter a column name, paste the JavaScript code in the editor, click “OK” and in order to load to the script press “Finish and reload”.
- To change an existing code, click the pencil icon. The red cross icon deletes the script.
- Predefined scripts can either be loaded from the code editor or through File > Presets > Pre pivot columns / Post pivot columns.
Please note that while users can write their own custom dynamic columns, Protein Metrics does not support custom code written by others, nor provides training or documentation to do so.