> For the complete documentation index, see [llms.txt](https://learn.canceridc.dev/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.canceridc.dev/cookbook/data-studio/cohort-dashboard.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.