Site Shared Data Views

Introduction

Flywheel captures a great deal of data and metadata from imported data sets, processing results, and information added by users. Data Views can be used to create a tabular report using this data. The Data View specifies how the data should be queried to generate the report. The Data View can be reused by others on the project or to generate a new report with the latest data in Flywheel.

Example: Create a demographics report for all of the subjects in a study or aggregate data from the exams in a longitudinal study to assess changes over time.

Instruction Steps for Site Shared Data Views

Create, View and Edit Shared Data Views

Site admins have the ability to view and create Shared Data Views. Shared Data Views will automatically appear in each project under the tab Shared Data Views. Users in that project can run the Data View against their own project data to generate a report. This allows you to standardize reporting throughout the site.

1. Navigate to the Admin section on the left Navigation pane of Flywheel.

   

2. Click Data Views to see the list of Shared Data Views across the site.

   

To Create a Shared Data View

1. Click Create New Data View.

2. Enter a name and a short description so other users know what type of report they are generating.

3. Begin typing in the Available Columns to filter field names. Note that the available columns list includes only Flywheel's default fields in this view. Additional fields, such as custom metadata, are available by using the 'Filter Available Columns' search. Note that Project level data can not be included in a Data View.

4. Select the arrow to add the field to Selected Columns.

5. Click on a field in Selected Columns to edit the alias. The alias will be the column header in the report.

   

6. Press Save to save the Data View.

To View or Edit a Shared Data View

Click the name of the shared Data View . This opens up the shared Data View for editing. Editing is similar to editing a Data View at the project level. The only difference is that you can not preview or execute the shared Data View, since it is not associated with a project.

Promote A Project Data View to a Shared Data View

Once a Data View is executed on a project, it can be promoted to a Shared Data View. This is a convenient way to share Data Views from a project across the site.

1. Select the Data Views Tab on the particular project with the Data View you would like to promote.

2. Click on the name of the Data View to execute the view.

3. When the report is complete, click the Promote button to create the Shared Data View.