Overview

Generate The Panelist Daily Attendance Report

1. In the Dashboard, from the black ribbon at the top, select Libraries > Panelists.
   
   
2. Click the Reports tab.
   
   
3. Under the 1. Report type, select Panelist daily attendance report.
   
   
4. Under the 2. Panelists, select Add panelists and select one of the following:
   
1. Add panelists from panel. This option is useful when you have a specific panel you want to run the report on, or a subset of panelists from that one panel.
   
   --or
   
   
2. Find panelists to add. This option is useful when you need to generate the report on panelists that are not necessarily in one specific panel, or you are not sure what panels they all belong to.
   
   When you find and select panelists you wish to generate the report on, click Add selected. Click 2. Panelists to collapse it, or scroll further down on that page for the next step (the 3. Options).
   
   
5. Under the 3. Options:
   
1. On the left, select the information you wish to include in the report. You do not need to include any of the fields if you do not want. The Username/Code will be included by default.
   
   
2. On the right, specify the date range you are interested in. The date range selection is mandatory and it represents the time frame within which panelists completed their sample sets. The default range is from 7 days ago to today.
   
   
6. Click 3. Options to collapse it, or scroll down and click Create my report. Download and open the report to review.
   

The Report Details

1. Panelists are in rows.
   
   
2. Columns contain the panelist fields that you may have selected.
   
   
3. Following the panelist information columns are columns with dates on which panelists completed their sample sets. The dates are within the range that you specified before generating the report.
   
   If at least one panelist completed their sample set on a day within the range you set, that day will be included in the report.
   
   If no panelists completed any sample sets on a specific date, the date will not have a column on these sheets. For example, if you typically do not run tests on Fridays, you should not see in the report any dates that fall on a Friday even when they are within the date range that you specified.
   
   
4. Below the header row is a row displaying totals for each date.

1. Complete response by day.
   
   
   On this sheet:
1. If a panelist completed at least one sample set on a specific date, they will have a checkmark with the green background in a cell for that date.
   
   The checkmark does not necessarily equal the number of tests they completed that day. This is because a panelist could have completed more than one test in a single day. The next sheet provides the test totals.
   
   
2. If a panelist did not complete at least one sample set on a specific date, the cell will be blank for that panelist.
   
   
3. The "% days attended" column provides the percentage per panelist calculated as follows:
   
   % days attended = (the total number of checkmarks a panelist has / the number of day columns in the report) * 100.
   
   
   
   
2. Tests per day.
   
   
   On this sheet:
1. If a panelist completed one or more tests on a specific date, the number of tests they completed will be indicated under that date.
   
   
2. If a panelist did not complete any tests on a specific date, it is indicated with a zero (0) under that date.
   
   
3. The Total column displays the total number of tests panelists completed across all the days displayed in the report.