IDC User Guide
  • Welcome!
  • 🚀Getting started
  • Core functions
  • Frequently asked questions
  • Support
  • Key pointers
  • Publications
  • IDC team
  • Acknowledgments
  • Jobs
  • Data
    • Introduction
    • Data model
    • Data versioning
    • Organization of data
      • Files and metadata
      • Resolving CRDC Globally Unique Identifiers (GUIDs)
      • Clinical data
      • Organization of data, v2 through V13 (deprecated)
        • Files and metadata
        • Resolving CRDC Globally Unique Identifiers (GUIDs)
        • Clinical data
      • Organization of data in v1 (deprecated)
    • Downloading data
      • Downloading data with s5cmd
      • Directly loading DICOM objects from Google Cloud or AWS in Python
    • Data release notes
    • Data known issues
  • Tutorials
    • Portal tutorial
    • Python notebook tutorials
    • Slide microscopy
      • Using QuPath for visualization
  • DICOM
    • Introduction to DICOM
    • DICOM data model
    • Original objects
    • Derived objects
      • DICOM Segmentations
      • DICOM Radiotherapy Structure Sets
      • DICOM Structured Reports
    • Coding schemes
    • DICOM-TIFF dual personality files
    • IDC DICOM white papers
  • Portal
    • Getting started
    • Exploring and subsetting data
      • Configuring your search
      • Exploring search results
      • Data selection and download
    • Visualizing images
    • Proxy policy
    • Viewer release notes
    • Portal release notes
  • API
    • Getting Started
    • IDC API Concepts
    • Manifests
    • Accessing the API
    • Endpoint Details
    • V1 API
      • Getting Started
      • IDC Data Model Concepts
      • Accessing the API
      • Endpoint Details
      • Release Notes
  • Cookbook
    • Colab notebooks
    • BigQuery
    • Looker dashboards
      • Dashboard for your cohort
      • More dashboard examples
    • ACCESS allocations
    • Compute engine
      • 3D Slicer desktop VM
      • Using a BQ Manifest to Load DICOM Files onto a VM
      • Using VS Code with GCP VMs
      • Security considerations
    • NCI Cloud Resources
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
Export as PDF
  1. Cookbook
  2. Looker dashboards

Dashboard for your cohort

Use IDC-provided Looker Studio template to build a custom dashboard for your cohort

PreviousLooker dashboardsNextMore dashboard examples

Last updated 3 months ago

Was this helpful?

You can use to build a custom dashboard for your own cohort, which will look like the screenshot below in three relatively simple steps.

Step 1: Prepare the manifest BigQuery table

Export the cohort manifest as a BigQuery table, and take note of the location of the resulting table.

Step 2: Duplicate the template

When prompted, do not change the default options, and click "Copy Report".

Step 3: Configure data source

Select "Resource > Manage added data sources"

Select "Edit" action:

Update the custom query as instructed. This will select all of the DICOM metadata available for the instances in your cohort.

For example, if the location of your manifest table is canceridc-user-data.user_manifests.manifest_cohort_101_20210127_213746, the custom query that will join your manifest with the DICOM metadata will be the following:

SELECT
  all_of_idc.*
FROM
  `canceridc-user-data.user_manifests.manifest_cohort_101_20210127_213746` AS my_cohort
JOIN
  `bigquery-public-data.idc_current.dicom_all` AS all_of_idc
ON
  all_of_idc.SOPInstanceUID = my_cohort.SOPInstanceUID

Once you updated the query, click "Reconnect" in the upper right corner.

Make sure you select a valid Billing Project that you can use to support the queries!

Accept the below, if prompted (you may also be notified about changes to the schema of the table, so the message may be different).

Click "Done" on the next screen:

Click "Close" on the next screen:

You are Done! The dashboard for your cohort is now live: you can "View" it to interact with the content, you can edit it to explore additional attributes in the cohort, and you can choose to keep it private or share with a link!

Open the dashboard template following this link: , and click "Use template" to make a copy of the dashboard.

http://bit.ly/3jdCmON
this Looker Studio template
Screenshot of the DataStudio dashboard template you can use to explore your cohort.
Name of the BQ table you will need is highlighted with the red rectangle.