Get Empowered: Using, Modifying, and Creating Report Methods | Tip #157, Creating Advanced Summary Reports

By January 22, 2020


Tip #157:  Creating Advanced Summary Reports in Empower Software

Welcome back to Get Empowered! In the last Empower tip-of-the-week post for Empower Chromatography Data Software, we learned how to create a simple summary report (Tip #156).

In this week’s tip, we will create an advanced summary report. The sample set has multiple injections per sample and two channels collected per injection. Our goal is to summarize the channels collected while maintaining the statistical summaries.

Let’s get started.

Step 1

Highlight ‘Results’, right click and select ‘Preview/Publisher’ (figure 1).

Figure 1

Figure 1

Step 2

Continuing with the summary report we created in Tip #156, the chromatograms for both channels are in a stack plot, and the tables are already separated by channel (figure 2).

Figure 2

Figure 2

Step 3

The report can be improved by making a composite group out of the chromatogram and the table so we can add sorting. In the report publisher, highlight both groups and select ‘Group’ from the Edit menu (figure 3).

Figure 3

Figure 3

Step 4

Select ‘Composite Properties’ from the Edit menu (figure 4).

Figure 4

Figure 4

Step 5

Add ‘Channel’ from the Chromatogram fields to the ‘Order By List’ in ‘Ascending’ order, click ‘OK’ (figure 5).

Figure 5

Figure 5

Step 6

Optionally, we can add ‘Channel’ to the ‘Legend’ in the chromatogram properties (figure 6).

Figure 6

Figure 6

Step 7

The report now displays the overlay for the replicate injections of Channel 1 with the corresponding table followed by the same for Channel 2 (figure 7).

Figure 7

Figure 7

Step 8

Why was the table already split by channel? Since this is a preconfigured component summary group, the primary sort is by ‘Channel’ in ‘Ascending’ order and is grouped by channel (figure 8). How does it work? Every time the value in the channel field changes it makes a new table. The first 3 results are for Channel 1. The fourth result is for Channel 2. Once it sees that change in value it starts a new table.

Figure 8

Figure 8

It’s that easy!

Final Note:  This procedure can be followed using the QuickStart or Pro interface.

 

Please rate this Empower Tip of the Week


Next week in Empower Tip #158 – Next week we will continue our series on Report Methods and learn how to create a slightly more complex summary report.

 

More Resources:

 

 

Do you want Empower Tips sent to your inbox every week?

Subscribe Now

Questions? Tips of your own? Let us know!

 


Categories: Empower Tips