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

How to show column with numbers as data type in a table view - see description

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi All,

 

I have a column named project numbers and the data type is number.

 

I wanted to show all the projects numbers in a table view but since "Project Number" is shown under category "metrics" whenever it is shown in a table view it will get aggregated to sum or count.

 

How can i show all the project numbers in a table without aggregating?

 

Thank you,

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Vibin V
June 2017

How to show column with numbers as data type in a table view - see description

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

vibin

 

create another metric and display it there, project should be under dimension not metric

View solution in original post

How to show column with numbers as data type in a table view - see description

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

just make aggregation as "none", and then it become a dimension

 

How to show column with numbers as data type in a table view - see description

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I changed the aggregation as "None". So now I don't have anything as a "numeric". So it is showing as "invalid metric" under the metric category. How can i solve this? Unless I add something under "metric" I won't get the table displayed

Marked as Best Answer.
Solution
Accepted by topic author Vibin V
June 2017

How to show column with numbers as data type in a table view - see description

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

vibin

 

create another metric and display it there, project should be under dimension not metric

How to show column with numbers as data type in a table view - see description

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

ok it's working now.

 

Thanks so much :-)