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

Invalid Dimension - how to set up data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am as new as you can be to data-studio. I have a simple table with services listed in column A and years across row 1. When I connect this sheet to Data Studio the metrics (years) import, but the dimension is listed as 'invalid' so it will not create any graphs/reports. I am sure I'm missing something super basic, but can't seem to figure it out.  

Invalid Dimension - how to set up data

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I am having the same issue. Any help anyone?

Invalid Dimension - how to set up data

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

I'd suggest setting your data up like this:

 

Service 1   Year 1   Metric

Service 2   Year 1   Metric

Service 1   Year 2   Metric

 

The way you have it set up, Data Studio will read each year column as a different metric instead of the same one broken out by year. Once you have the data in there, you can filter by year, or make line or bar charts that you break down by year.

Invalid Dimension - how to set up data

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

My date column is in the format "YYYY-MM-DD", can this be used?