Hide Pivoted Column


We have a case where we can’t filter a pivot because it would affect a table calculation, but we’re only interested in a subset of the pivoted results. For now, there are many extra series in the visualization that are disabled. I would be nice to have the “Hide from visualization” option affect each individual column rather than every column with the same key.


25 replies

Userlevel 2

You can click the colorful indicator in the legend to hide that column. I believe this persists when the look is saved. Not exactly what you want, but hopefully helpful.

Userlevel 5
Badge

Yeah, @JohnLemberger as @Michael suggested, hiding the series in the visualization is probably the best option for the immediate term. I’ll make sure that our product folk get eyes on this, though

Hey Rachel, Is there a way to remove on the of the values in the pivot column? When I select hide from visualization for the pivoted column it hides all the categories under the column.

Userlevel 2

Hey @SubhasreeC,


At this time there is not a way to hide only one column within the pivot from the visualization, but I will definitely let the product team know this is something you’d like to see! Hiding one series is possible via the visualization legend and by holding the option key while clicking as shown above.

Userlevel 1

Hi @cutler, have you implemented this feature by any chance ?


Thanks in advance


PS : additional question, would it be possible to hide a column based on total calculations ? or display only the first n columns, ranked by the total of the measure, instead of the alphabetical order of the column pivot name ?

Userlevel 5
Badge

The feature isn’t implemented, but you can mimic it by creating table calculations using pivot_where() or something or something similar to duplicate the columns you do want and then hiding the entire underlying field.


  • 1 for this feature


  • 1 for this feature

Userlevel 1

++1 for this too!

+1 for this feature as well, please!


  • 1 for this feature !

Thanks, @cutler, this approach worked visually at least. However applying this to multiple tiles within one dashboard has unfortunately led to almost unusable load times.


I have a table aggregating one measure while pivoting by time frame, with some simple table calculations for % change from each previous time frame to the current time frame (MoM, YoY, etc.). Then I have pivot_where() applied to the table calculations themselves to only display results for the current time frame, with all underlying columns hidden as suggested. Seems pretty straightforward, but I guess the pivoting + table calculations + pivot_where on top of table calculations wreaks some havoc.


I’m all ears if someone has discovered a better solution for this! In the meantime, +1 for this feature 😄

+1 for this feature

+1 for this feature

+1 for this feature

+1

+1 for this feature

+1 for this feature

+1 for this feature

+1 for this feature

Userlevel 1

+1

Userlevel 2

+1

+1 for this feature.

--

With the “Table” layouts, I can’t find a way to hide a specific pivot value (while it’s available on other visualisation layouts).

--

Edit: Fixed with @lexideveaux solution (message below) 

Hi all, 

I would recommend hiding columns under a pivot by using the pivot_index() to select the columns you want to show. So for example, if I want to only SHOW the count measure under the cancelled pivoted value : 

i can create a table calc pivot_index(${orders.count},1) 

And then hide the original measure. Now in my visualization only the cancelled count table calc will show

I love all the creative ideas here and the community rallying together to make this a feature. It’s a +1 from me dog. 

Reply