How do I use a School Year Participant Demographic Report? – Link2Feed

This report provides demographic information for participants.

This article covers the following topics:

Additional steps following basic setup

Please see Report Setup Foundations for all reports' basic setup steps.

When running a report, users will see a Show Inactive toggle option. By default, it will be off. When enabled, sites that are inactive will show on the organization's list so they can be reported on.

Additional steps:

After completing the Report Setup Foundation you will need to select the Meal Types you would like to include on the report.
Participant Types you want to include in the report (Adults, Children, Non-Program Adult, etc.).
You will also need to indicate which Program Types you want to include data for.
Click Create Report at the bottom, your report will be found in your Report Inbox on the left-hand side of the screen under Reports. Alternatively, you can hit Save Template if you want to save this as a template for future use. More on templates can be found here.

Table overview

Table and Query Definitions

Organization: Name of the organization. A row for each organization will appear in the report.
Ethnicity
- Hispanic or Latino: Aggregate a unique count of all individuals who selected Hispanic for at least one racial category.
- Non-Hispanic or Latino: Aggregate unique count of all individuals selecting only:
  - White / Anglo
  - Black / African American
  - Pacific Islander
  - Alaska Native / Aleut / Eskimo
  - American Indian / Native American
  - Asian
  - Arab American
  - Other
  - N/A
  - Undisclosed
Race (American Indian or Alaskan Native, Asian, Black or African American, White): Duplicate count of any individual who selected that race.
Gender: Aggregate a unique count of participants by gender.
Age: Aggregate a unique count of participants by age listed in chronological order.
Grade Level: Aggregate a unique count of participants by grade level listed in chronological order.

Export options

Click on the Export button to download the report as a CSV file to open in Excel.
Click on the Print View button to see the printer-friendly version of the report.

Efficiency and Timeliness of Report Generation

In our report generation process, we understand the significance of minimizing wait times for our users. Currently, the wait time is determined by the number of organizations included in the report and the duration covered. Let's delve into the details of our report queues for a clearer understanding.

We manage two queues: one for regular reports and another for large reports. We allow up to 20 reports to run simultaneously. This setup enables concurrent processing of multiple reports but may result in a slightly extended initial wait time to ensure efficiency.

Report size is determined by multiplying the number of sites by the duration in days, with a limit set at 50 sites x 180 days (equivalent to 9000). Anything exceeding this threshold is directed to the large queue.
Recognizing the complexity and scale of large reports, they are processed in a separate queue, occasionally resulting in wait times measured in hours. We understand the inconvenience and are actively working towards optimizing processing times for such reports in the future.

Conversely, our regular queue processes reports efficiently with a minimum wait time of 6 minutes per report. Multiple reports can run simultaneously, minimizing overall slowdowns. However, there are instances where regular reports may take longer, ranging from 20 to 30 minutes each. It's essential to note that even a quick report may experience delays if queued behind longer reports.

As we strive to optimize report processing times, your feedback is crucial. Please feel free to share your thoughts and suggestions, these contribute to our ongoing efforts to enhance and streamline this process for an improved user experience.