Sort analysis export using an analysis template

This feature was added in vintrace version 5.2.3

This feature allows you to select an analysis template to be used to sort the metrics when you export the CSV or PDF from Lab Console, generate the Analysis data export, or generate the Lab job worksheet. You also have the option to exclude metrics not on the selected analysis sort template and to include columns for metrics in the sort template even if there are no requests present.

Using analysis sort template in Lab Console

Firstly, you need to request lab work for some wines you want to run through the lab. Please refer to this post on how to request, export, and import lab jobs.

For our example below, we have requested a lab sample with the following metrics selected: Alcohol, Amino, and Baume.

Lab request

Go to ConsoleLab Console. You can see the lab work you have requested with the three metrics Alcohol, Amino, and Baume.

lab console advanced report options 6

Let’s say you want to export the lab request to a CSV file but you want the metrics to be sorted according to an analysis template that you already have. For this example we have an analysis template, ‘Brix and Alcohol’ where Brix is listed first then Alcohol.

Analysis template

Click on the menu icon beside the CSV button on the lower part of the Lab Console screen.

Lab console advanced report options

In Analysis Sort Template field, click on the magnifying glass icon to search for the analysis template you want to use. In the example below, we have selected ‘Brix and Alcohol’ analysis template, which lists the Brix first then the Alcohol metric.

Lab console advanced report options 2

We also ticked the Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present checkboxes. Then click on Save button to save the selection. You can also click on the heart icon beside the options so that vintrace will remember your selection.

Lab console advanced report options 3

Click on CSV button to generate the CSV output.

Lab console advanced report options 4

In the CSV output, the metrics are sorted according to how the metrics appear in the Brix and Alcohol analysis template, where Brix is listed first. Amino and Baume is not in the CSV since we have Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present option selected. Brix is included in the CSV output even though there was no lab request for it because we have selected the Include columns for metrics in the sort template even if there are no requests present option.

Lab console CSV output

Using analysis sort template in Lab job worksheet

Go to Winery Reports – Product analysis – Lab job worksheet. We want to see the lab work requested in the previous section. Under Metrics, select Alcohol, Amino, and Baume.

Lab job worksheet 1

In the Advanced Report Options – Analysis Sort Template, select ‘Brix and Alcohol’. Let’s assume we want to see all the metrics requested plus any metrics that are in the analysis template even though there are no requests for it, so tick on Include columns for metrics in the sort template even if there are no requests present checkbox.

Lab job worksheet 2

Click on Generate button.

Lab job workshee 3t

In the generated results, the metrics is sorted in the following order: Brix, Alcohol, Amino, and Baume. If there are metrics included that are not in the analysis template, it will be added to the end of the list. In this case, Amino and Baume are added after Brix and Alcohol.

Lab job worksheet results

Using analysis sort template in Analysis data export

Go to Winery Reports – Product analysis – Analysis data export. Assuming that the lab requests from the previous sections have been completed and we want to export the analysis data and sort the metrics according to the ‘Brix and Alcohol’ analysis template. In Advanced Report Options, select ‘Brix and Alcohol’ in the Analysis Sort Template. Then click on Generate button.

Analysis data export

In the CSV output, the metrics are sorted in the following order: Alcohol, Amino, and Baume. Brix is not included in the output since we did not have the Include columns for metrics in the sort template even if there are no requests present option selected

Analysis data export output.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *