# Dashboard for your cohort

You can use [this Data Studio template](http://bit.ly/3jdCmON) to build a custom dashboard for your own cohort, which will look like the screenshot below in three relatively simple steps.

![Screenshot of the DataStudio dashboard template you can use to explore your cohort.](/files/-MS4kaUIT20nK1zTx9EU)

**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.

![Name of the BQ table you will need is highlighted with the red rectangle.](/files/-MS4mQkLYrPYHJRo8Dye)

**Step 2: Duplicate the template**

Open the dashboard template following this link: <http://bit.ly/3jdCmON>, and click "Use template" to make a copy of the dashboard.

![](/files/-MSdYLMANevNG3jLSMIT)

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

![](/files/-MS4n7UW_xvwFX6KMR_g)

**Step 3: Configure data source**

Select "Resource > Manage added data sources"

![](/files/-MS4nTnPrIu0SCgvD7xX)

Select "Edit" action:

![](/files/-MS4o4M9_mfPrZ2iVWO1)

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

![](/files/-MS4oRns_nlNPaFFSjmd)

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:

```sql
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.

{% hint style="warning" %}
Make sure you select a valid Billing Project that you can use to support the queries!
{% endhint %}

![](/files/tq6GwiLgrNe1WK4qZzNg)

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

![](/files/-MS4paGIZrs7yZVvMmIJ)

Click "Done" on the next screen:

![](/files/-MS4pmmbY09judr1mwv0)

Click "Close" on the next screen:

![](/files/-MS4pxczqsVMNo_17DoM)

**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!

![](/files/-MS4qN-KfCufLpp3A7p-)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.canceridc.dev/cookbook/data-studio/cohort-dashboard.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.