is there a dimension where i can filter by most recent?

[ViraClick]

Hi! iv'e got this graphic in my report that shows all of the ads that i have published for my client, along with other metrics. the problem is that there is a bunch of different published ads in different dates, and i want to sort them so the most recent ones appear on top. i coudn't find any filter or dimension to do it

[Lobo-Google]

Hi @ViraClick, thanks for your post!

You can sort the data for most charts in Looker Studio. For example, you can sort a table chart by clicking on the column headers in the chart. This means that the date field that corresponds to an ad's creation date needs to be in the table. 

Other charts may have a Sort field, depending on the chart type. This lets you select a dimension to sort a chart by, without it necessarily appearing in the visualization (if you don't want it to). 

I recommend searching the Looker Studio documentation for the type of chart you are using, to see what sorting capability it has.

[Lobo-Google]

Hi @ewelinal, thanks for your post!

The Looker Studio Connect to Google BigQuery documentation page has some information about limits and quotas in the Quotas and general limits section. I hope that is helpful!