-
Notifications
You must be signed in to change notification settings - Fork 2
Technical Documentation
This drop-down allows the user to filter by site on contains all of the sites included within the data set. Selecting a site will only show the data associated with that site.
This drop-down allows the user to filter by freeze status. The current options are "All" (default) and "Not Ready to Freeze". Choosing a freeze status will only show subjects that are associated with that freeze status.
This drop-down allows the user to filter by subject status. The current options are "All" (default), "Completed", "Enrolled", and "Screen Failure". Choosing a subject status will only show subjects that are associated with that subject status.
System will allow users to subset the data using 3 pre-defined subset groupings. Each subset defaults to "All" and the subsets can be applied concurrently. The labels on these subsets are limited to 10 characters.
Users can select the checkbox to display the annotation for each cell. This annotation is a calculation of the percentage of completion for blue cells or the number of queries for green cells. Users can unselect the checkbox to remove the annotations in each cell.
Users can select the checkbox to expand all of the rows nested inside the ID column. Users can unselect the checkbox to collapse the nesting and only show the high level ID data.
Users can select options from the drop-downs to create a heat map by site, subject, form, or field. The selection made in the first drop-down will be the high-level variable and the selections in the second and third drop-down will further subset the data; the chart will default to show the data by site, with the subjects nested beneath it.
This legend indicates the percentage of completion for each form. the CRF legend uses blue shading, with light blue indicating less complete and the dark blue indicating more complete.
This legend indicates the number of queries captured for each column. The Queries legend uses green shading to indicate query status, with light green indicating less complete and the dark green indicating more complete.
Users have the ability to filter on a column between using an interactive slider. The filter will remove any records that do not fall within range for that column. Forms can be filtered to show data that falls between 0% and 100% and queries can be filtered to show data that falls between 0 and the max number of queries included in the data. Users can apply multiple column filters at a time. Users can reset the sliders to remove all of the column filters at once by selecting the "Reset sliders" button to the left of the slider controls.
The system will show small, white gridlines in between cells to separate them and make it easier for the user to differentiate between the column data.
Cells with a denominator of 0 will "N/A" to indicate that the form is not applicable to that instance. These cells are shaded dark blue to indicate that they are complete and they are represented as 100% when the user filters on a column that includes an N/A cell.
If the user opts to turn the cell annotations off, they can still view the annotations by hovering over the cells. If the user hovers over the following fields, they will see the percentage complete for each variable: CRF's Entered, Source Data Verified, Frozen, Signed, and Locked. If the user hovers over the Open Queries or Answered Queries cells, they will see the sum of queries for each cell
A data export button is located at the top of the page. Exports will capture the current filtered data along with the raw data. The second tab within the export spreadsheet lists which filters the user has selected to produce the current export
- Confirm that the 3 Summarize by drop-down filters at the top of the heat map have the following options. 1: Site, Subject ID, Folder, Form 2: Site, Subject ID, Folder, Form, None 3: Site, Subject ID, Folder, Form, None
- Confirm that the default values for the Summarize by filter are Site, Subject ID, and None
- Confirm that the Summarize by filters display the data in the correct nesting format. For instance, if the first drop-down is set to Site and the second drop-down is set to Subject ID, then the ID column should initially display Site IDs and when you click on a row it will expand to show the Subject ID rows
- Confirm that the Site drop-down filter to the left of the heat map contains all of the sites included with the dataset
- Confirm that the default value for the Site drop-down is All
- Confirm that selecting a site filters the chart to show only the data associated with that site
- Confirm that the Subject Freeze Status filter has 2 options: All (Default) and Not Ready to Freeze
- Confirm that the default value for the Subject Freeze Status filter is All
- Confirm that selecting Not Ready to Freeze shows only subjects associated with that status
- Confirm that the Subject Status filter has the following options: Completed, Enrolled, Screen Failure
- Confirm that choosing a Subject Status filter will only show subjects that are associated with that status
- Confirm that the default is for all of the Subject Status filter options to be selected
- Confirm that the 3 Subset filters to the left of the heat map have an option for All
- Confirm that the 3 Subset filters default to All
- Confirm that each Subset filter changes the display appropriately so that only the selected subset data is displayed
- Select and de-select the checkbox for Display Cell Annotations to confirm that the percentages and queries appear and disappear in the cells (%'s = completion percentage for blue cells and queries = number of queries for green cells)
- Confirm that selecting the Expand All checkbox expands the ID column to show all of nested data
- Confirm that de-selecting the Expand All checkbox collapses all of the nested data and only the high level ID's are displayed
- Confirm Users can select options from the first drop-down at the top of the page: site, subject, form, or folder
- Confirm the CRF legend appears at the top of the page. It has %'s that range from light blue to dark blue, with the darker the blue indicating the higher % of complete
- Confirm the Queries legend appears at the top of the page. It has the number of queries completed that range from light green to dark green with the darker green indicating the higher number of complete
- Confirm that each column has filter sliders that appear at the top of each column in Firefox and Chrome
- Confirm that each column has input boxes that appear at the top of each column in IE
- Confirm that Form columns have a range of 0% to 100% and Query columns have a range of 0 to the max number of queries within that dataset
- Confirm that multiple column sliders can be adjusted simultaneously
- Confirm that the Reset Sliders button removes the filters and returns each column filter to the default
- Confirm that gridlines appear between cells
- Confirm that when cell annotations are turned off, hovering over the cells in following fields will still have the % data appear: CRF's Entered, Source Data Verified, Ready for Freeze, Frozen, Signed, and Locked
- Confirm that when cell annotations are turned off, hovering over the cells in following fields will still have the query sums data appear: Open Queries, Answered Queries
- Confirm that data export buttons appear at the bottom of the page, CSV and XLSX
- Confirm that each option is able to produce an export of the current data opened in excel
- Confirm that if using the XLSX export option, a second tab appears which lists the filter options that were selected to produce the current data export
- Confirm that "Loading" text appears in the top left of the page when changing nesting or filters
- Confirm that the Subject Status filter is multi-selectable
- Confirm the three nesting controls appear above the chart
- Confirm the 3 Subset controls all have the same width
- Confirm the Webcharts controls appear to the left of the chart
- Confirm that a 'Ready for Freeze' column appears
- Confirm that a filter appears for 'Subject Freeze Status' and appropriately filters the data
- Confirm that hovering over the header of the Answered Queries column and verify that text appears explaining the column
- Confirm that if a subject is a nest variable that subject-level characteristics like 'Subject Status' appear in the output of an export
- Confirm that if a subject is not a nest variable then subject-level characteristics like 'Subject Status' do not appear in the output of an export
- Verify you can add custom labels to nesting columns
- Verify that the nest names appear as follows as defaults: Site Name, Subject ID, Folder, Form
- Confirm that when clicking on the export button, the output does not contain total rows for the nesting columns
- Verify that a csv export contains information on the currently applied filters
- Verify that an xlsx export contains information on the currently applied filters in the second tab but does not in the first tab
- Verify that N/A cells are labeled as such
- Verify that N/A cells are the same color as 100% columns (Dark blue)
- Verify that an 'Expand All' button appears and expands all the nests when clicked
- Verify that subject status, freeze status, and site appear in the export when subject is a nest level
- Confirm that the subset labels cannot exceed 10 characters