0

I created a table in Google Data Studio using Google Sheets as the Data Set:

Screenshot of the table

I changed the granularity of the date column to "Year month" to group the data in months. As you can see July 2020 is missing from the table. My source data doesn't have any values matching a date in July and that's why it is missing. But I want July 2020 to show up in the table with a "null" or "0" or "no data". I chose the setting the for "missing data" show "null" and yet its not showing up.

Added data set: Google sheet dataset

Karthik Radhakrishnan
  • 1
  • 2

1 Answers1

0

Two ways of going about it are:

1) Add data in the Data Set

The feature is currently not implemented in Google Data Studio Tables, thus one approach would be to add the Date (July 2020) at the Data Set (Google Sheet).

Update: Added a New Page to the Report as well as an image to demonstrate, where the highlighted rows in Orange represent the added Date, July 2020 (Note that NULL, 0 or the required value could be used as a metric):

2) Time Series Chart

Alternatively, a Time Series chart could be created, which would display the month of July as 0 (missing data is set to Line to Zero by default).

Google Data Studio Report and a GIF to elaborate:

Nimantha
  • 6,405
  • 6
  • 28
  • 69