The Consonance GraphQL API
  • Getting started
  • Bibliographic
    • Select filtered products and their work
    • Select works and their products
    • Select products filtered by price and format
    • Select products filtered by work attributes
    • Select works and their relevant marketing material
    • Sample AI/Tip Sheet
  • Production
    • Select works and their product production run details
    • Sample production request form
  • Legal
    • Select contract details
    • Select contract financial information
    • Select contract dates and rights
  • People
    • Select basic person details
    • Select person contact details
    • Select professional details
    • Select person details and contributing works
    • Select organisation details
  • Data exchange
    • Sample custom report sheet
    • Sample dashboard
Powered by GitBook
On this page
  • Explanation
  • Examples
  1. Data exchange

Sample dashboard

PreviousSample custom report sheet

Last updated 1 year ago

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

custom report
Google Data Studio screenshot. The dashboard shows a pie chart, a line graph, a bar chart and a pivot table.