Data Studio
2.1K members online now
2.1K 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

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

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 :-)