Knowledge Drop

Hide Pivoted Series from Visualization

  • 7 July 2021
  • 0 replies
  • 85 views

Userlevel 4
Badge

Last tested: May 4, 2020
 

Let's say that you want to hide a specific series from a pivoted table. What do you do? One option is to mirror all the columns manually with a pivot_where and leave out the column you want to hide. The other option is to use some visualization workarounds.
Go to the bottom of this post for a quick workaround how to hide series.

In our example below we want to hide the series from the year 2019.

This example shows the pivot_where workaround:
Screen Shot 2020-05-04 at 1.16.12 PM.png



Screen Shot 2020-05-04 at 1.16.12 PM.png



For the quick workaround:

- In the series panel, edit the label.
- Go to this website and copy and empty space. http://emptycharacter.com/
- Paste it in.
- Click on the colour square and insert a white hex code. #FFF works

In this example we want to hide the year 2019:

Screen Shot 2020-05-04 at 1.03.55 PM.png


Goodbye 2019.

Screen Shot 2020-05-04 at 1.11.13 PM.png

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply