Hide Data?

21 views
Skip to first unread message

Rylan Demers

unread,
Apr 21, 2025, 5:09:23 PM Apr 21
to looker-studio-developers-forum
Hello!

I am new to Google Looker. 

We are looking to use it as our Enrollment Dashboard. Currently, I have a pivot chart with Grade and Homeroom and the # of students in each homeroom as the metric.

Grade - HR \ # std
1 - Teacher A - 12
1 - Teacher B - 20
2 - Teacher A - 15

I really don't want to show the name of the homeroom but still "show" the students in each one.

Grade - HR \ # std
1 -  12
1 - 20
2 - 15

Any ideas? 

Thanks,
Rylan

BONNIE HICKS

unread,
Apr 22, 2025, 9:09:00 AM Apr 22
to looker-studio-developers-forum
Not really sure what your original source is but, based on the above, you could create a calculated field with something like: 

 CONCAT(LEFT_TEXT(fieldname,3),RIGHT_TEXT(fieldsname,3))

Reply all
Reply to author
Forward
0 new messages