Query Volume by Month by Site

Previous Topic

Next Topic

Book Contents

Query Volume by Month by Site

This report shows the number of queries opened, answered, and closed in each month for a range of months.

Site managers use this report to see if query volume or query handling is changing negatively over the course of a study.

Tip Tip: For the best performance, do not select any optional filters on the Selection Criteria page.

Graphs

A bar graph appears on the first page of the report, plotting the query volume by month and site.

Subtotals and totals

Column descriptions

Column descriptions

Column

Description

Country

Data type: String

Description: The country in which a site is located, as entered in the InForm Administration interface.

Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.

Site Mnemonic

Data type: String

Description: An abbreviation that identifies a site, as entered in the InForm Administration interface.

Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.

Month, Year

Data type: String

Description: Month, Year for each month in which there is query activity (queries opened, answered, or closed).

How calculated: For each query, extracts month and year portion of the date the query was first opened, first answered, and last closed.

Open

Data type: Numeric

Description: The number of queries that were opened in a given month.

How calculated: Counts queries that were opened in a given month, based on your selections in the Query Status, Query State, and Limit to Reissued prompts on the report prompt page.

Data source: Derived for the report; not stored in the Reporting and Analysis database.

Answered

Data type: Numeric

Description: The number of queries that were answered in a given month.

How calculated: Counts queries that were answered in a given month, based on your selections in the Query Status, Query State, and Limit to Reissued prompts on the report prompt page.

Data source: Derived for the report; not stored in the Reporting and Analysis database.

Closed

Data type: Numeric

Description: For each site, the number of queries that were closed in a given month.

How calculated: Counts queries that were closed in a given month, based on your selections in the Query Status, Query State, and Limit to Reissued prompts on the report prompt page.

Data source: Derived for the report; not stored in the Reporting and Analysis database.

Total

Data type: Numeric

Description: For each site and visit, the total number of open, answered, and closed queries in a given month.

How calculated: The sum of the values in the Open, Ans'd, and Closed columns.

Data source: Derived for the report; not stored in the Reporting and Analysis database.

Send Feedback