AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Table Columns - Custom metrics date ranges

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to create a single table to show the different data for a dimension across different date ranges. Is this possible through creating customized metrics with calculated metrics?

 

E.G. I need one table for dimension: product sku with metric: product revenue, but I need columns with product revenue for the current month, last month, prior period and year to date. Does anyone know if its possible to do this in one table?

 

I can create multiple tables with the specific date ranges, it always has to show the column with the dimension, if I could turn off visualisation of the dimension and just show the metric data then I could align the columns to show the data sequentially, otherwise its not as easy to understand the data.

 

Any suggestions would be great.