Skip to main content

Dahlgren Memorial Library

Creating Dashboards with Google Data Studio

Use this guide to follow along during DML's Google Data Studio Workshop

Insert Date Filter

Click "Insert--Date Range" to insert a date filter at the top of the chart. This filter allows users to explore the data for different time periods. Although this filter won't apply to our scorecard metrics, they will be useful for filtering the data in our time series charts. 

insert date range filter

Click "Insert -- Time Series" to insert two line graphs. The first compares total deaths to total cases over time. Drag "SUM - deaths" and "SUM - confirmed cases into the "metric" column to display these two lines. 

setting up chart one

The second chart displays totals by country. To generate the lines for each country, drag "country_region" into the "breakdown dimension" column. Toggle the "optional metrics" option on. Drag "SUM - confirmed cases" under "optional metrics". Adding an optional metric allows users to toggle the visualization between data on total deaths and total confirmed cases, making for a more dynamic dashboard experience. 

add time series two


Insert Time Series Charts