The imported list archive includes four lists interconnected with some lookups between them. These lookups allow us to create joins between these lists which pays off when we investigate our experimental results in the NIMHSlides list. The Slides list shows an interesting pattern in positive/negative stains, but you won't see this pattern unless you first join in some information from another list (NIMHDemographics).
- Click the NIMHSlides list from the Lists web part.
The grid shows all the uploaded slide data. You may or may not be able to spot a pattern at this point. Familiarity with the novel might help in this very simple example, but we can also use additional data to help us.
Create a Joined Grid
- On the NIMHSlides grid, select (Grid Views) > Customize Grid.
- In the Available Fields panel, expand the node SubjectID by clicking on the icon next to it.
- Place checkmarks next to the Name, Family, and Species fields. (Note that these fields are added to the Selected Fields panel.)
- Click Save.
- In the Save Custom Grid View popup menu, select Named and name this view NIMHSlideDataJoinedView. Click Save.
- You'll now see additional columns in the grid view. To view an interactive example, see: NIMHSlideDataJoinedView
Find a Pattern in the Data
Do positive/negative stains correlate with any other characteristics in our subjects?
First, let's do the simplest possible data analysis: sorting the data.
- Click the column header Stain Positive to bring up a menu of sorting and filter options.
- Choose Sort Descending.
- Examine the results and notice that almost all of the positive stains came from field mice.
- Looks like we have a pattern worth further investigation.