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: 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
- Subtotals—By Country.
- Totals—Overall query count 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. |