I've got data in a Google Sheet. There are X # of rows for specific report dates. As more data is dumped into the sheet, X # of rows are added and tagged with that report date.

This is a sample of the source data in a Google Sheet:

I have this added as a data source to Data Studio and created a table with the data like so:

I want to have the report automatically shows only the data for the last/latest report date set. So in the above example it would be 2022-02-01:

More data would be added to the sheet, so the logic in Data Studio has to be dynamic.

Sample data:

• Data set (Google Sheets)
• Google Data Studio report

CodePudding user response：

It can be achieved with a blend and creating a MAX(Date) field (a date field aggregated by MAX) and using it as a metric and join condition so that only the latest date and respective data are displayed:

1) Blend Fields

Table 1	Table 2
	Dimension 1: Report Date
	Dimension 2: ID
Metric 1 Name: Report Date Formula: MAX(Report Date)
Date Range: Report Date (Auto)

2) Join Configuration