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
3.3K members online now
3.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Ordering columns in a table

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

A quick question - is it possible to change order of columns in a table? It is easy to change order of dimensions just by drag & drop, but I need my metrics column to be the fist column in a table rather than the last - so far I have not found a way to do it. Any suggestions welcome Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Mike G
May 2017

Ordering columns in a table

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

so you need that your colomn will be a dimension. 

the 1st column is still a dimension. 

 

To made a field dimension, click on the pen to edit your data source

Then your field value need to be without aggregation. Set it at "none" (you can change it after)

Create a new field

formula is : 
CAST(yourfieldvalue AS TEXT) 

and create your field

 

When it's done, change the aggregation of your field value to put the old right

 

Now, you can choose your new field as Dimension to be place in first in your chart table. 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Mike G
May 2017

Ordering columns in a table

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

so you need that your colomn will be a dimension. 

the 1st column is still a dimension. 

 

To made a field dimension, click on the pen to edit your data source

Then your field value need to be without aggregation. Set it at "none" (you can change it after)

Create a new field

formula is : 
CAST(yourfieldvalue AS TEXT) 

and create your field

 

When it's done, change the aggregation of your field value to put the old right

 

Now, you can choose your new field as Dimension to be place in first in your chart table. 

Ordering columns in a table

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks! Too bad there is no easier way of doing it Smiley Happy