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 305
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
Top Solution Authors