> For the complete documentation index, see [llms.txt](https://gp0.gitbook.io/graphql-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gp0.gitbook.io/graphql-docs/data-exchange/sample_dashboard.md).

# Sample dashboard

Populate a dashboard of charts and graphs using Google Looker Studio (formerly Google Data Studio)

## Explanation

Using Google Sheets and Google Looker Studio you can populate charts and graphs to create a dashboard of your data.

**Prepare Your Data in Google Sheets:**

* Start by building a [custom report](/graphql-docs/data-exchange/sample_custom_report.md)  in Google Sheets. Include all the fields you need for your dashboard.
* Run this report at least once to ensure your data is up-to-date.

**Set Up Your Report in Looker Studio:**

* Open Looker Studio and create a new report.
* Choose Google Sheets as your data source from the available Google Connectors.

**Connect Your Custom Report:**

* Link the custom report you created in Google Sheets as your data source.
* Select the appropriate spreadsheet from your Google Sheets.
* When prompted with a warning about adding data to your report, select `Add to Report` to proceed.

**Add Charts to Your Dashboard:**

* Utilise the options in the main navigation or sidebar in Looker Studio to add charts.
* Use the fields from your custom report in Google Sheets to populate these charts.

**Refresh Your Data:**

* To update the data in your dashboard, go to `View > Refresh Data` in the main navigation bar.
* Alternatively, you can use the keyboard shortcut `Ctrl+Shift+E` to refresh the data.

Regularly refreshing your data ensures your dashboard reflects the most current information. Experiment with different chart types in Looker Studio to best represent your data.

### Examples

Total products filtered by format, publication status, sales territories or publication date

![Google Data Studio screenshot. The dashboard shows a pie chart, a line graph, a bar chart and a pivot table.](/files/KAQhZKqGtLMsSbVRYga1)


---

# 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://gp0.gitbook.io/graphql-docs/data-exchange/sample_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.