Knowledge Drop

How do I hide one of my pivot columns?

  • 7 May 2021
  • 1 reply
  • 205 views

Userlevel 3

Last tested: Mar 16, 2020
 

If you find yourself here, +1 this feature request: https://feedback.us.pendo.io/app/#/case/17612

We're here, and we want to hide the "other" column:image.png

We can accomplish this with pivot_index or pivot_where.

You'll need to create a table calculation for each column you want to show, then hide the original measure.

pivot_index(${your_measure_here},column_to_show)

This ends up looking like this:image.png

And in the visualization looks like this:image.png

 

This content is subject to limited support.                

 

 


Reply