Extract the last x records updated each days

Looker Q&A Looker Studio
1

Hi

Each day a google sheet datasource is updated with the data of the day

From this table I would like to update my report only with the last 365 records from this table

Thx

2

@PACAP
Doable but you need to push data into BigQuery and use some smart INSERT or MERGE INTO with WHERE clause appending or replacing only data you nneed.

Arkady Zagdan - Bigglo

3

Hi @ArkadyZagdan

Doable from the free or sandbox versio, ? Could u tell me a little bit more On How ?

Thx

1 Like
4

Or easier with this formula in google sheets : =QUERY(DATA;“SELECT A, L order by A desc LIMIT 365”)

5

@PACAP If that field is insert time or an progressing ID then yeah Query would do the work.