SQL-Befehl für Datastudio SELECT * FROM ( SELECT *, RANK() OVER ( PARTITION BY timeperiod ORDER BY _sdc_report_datetime DESC ) AS latest FROM `tablename` ORDER BY timeperiod ASC ) WHERE latest = 1   Links: https://www.stitchdata.com/ https://cloud.google.com/