Announcements
Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

Limit Displayed Columns

kccanut
Participant I

Can we limit the number of displayed columns as we do for displayed rows like in this screenshot?

I dont mean the Column limit when data is queries. 

cd207ef1-5bb7-4447-ae02-83c2b36bbb02.png
0 1 151
1 REPLY 1

jcdufault
Participant II

Hello Koray, 

Under the data section at the bottom, click on gear icon of the measure or dimension you want to hide and select “Hide this field from visualization”.

1803ea77-b099-49a9-9012-e0782732da54.png

If you have a pivot involved, and you want to hide only 1 of the pivot results, there will be an “Hide this column from visualization” option.

Finally, if you have a pivot with a dynamic number of columns and you always know the ones you want to show, you can hide everything from visualization and instead create a table calculation like so: 

pivot_index(${your_measure_here},column_to_show)
Top Labels in this Space