Skip to main content
Solved

Hide empty rows OR columns

  • May 31, 2022
  • 5 replies
  • 702 views

Is it possible to hide only empty rows or columns? Currently in the filter I see the “Hide empty rows / cols” option, but what if I just need to hide empty columns? 

Thanks! 

 

Best answer by CamilleMomo

Hi Luigi,

In the meantime, a workaround can be to use a metric to filter the columns in a table. For example in this view I use a metric “Week start ?” to only display days corresponding to the start of a week :

 

NB : You can hide the metric afterwards

5 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • 227 replies
  • June 3, 2022

Hi Luigi,

 

very much demanded ! And in the works ! I’m not sure of the expected arrival, will check it.


CamilleMomo
Master Author
Forum|alt.badge.img+14
  • Master Author
  • 27 replies
  • Answer
  • June 23, 2022

Hi Luigi,

In the meantime, a workaround can be to use a metric to filter the columns in a table. For example in this view I use a metric “Week start ?” to only display days corresponding to the start of a week :

 

NB : You can hide the metric afterwards


francois
Employee
Forum|alt.badge.img+13
  • Employee
  • 171 replies
  • June 23, 2022

Nicely spotted @CamilleMomo ! Filters have since been updated and you can indeed filter on the finest level of the hierarchy with either a condition (Metric Value is not blank) or a special, additional metric where you specify the condition yourself with a boolean.

If you don’t want to see the filter (those blue squares at the bottom of the view) you can right-click on it and hide it. It will still be in the view for Pigment to filter but it won’t show up in your nice board.


Chris
Wallflower
Forum|alt.badge.img+14
  • Wallflower
  • 385 replies
  • July 20, 2022

Hi @Luigi ,

 

I have some good news for you!  We just announced the ability to hide empty rows or columns

 

Thanks for the feedback, hope you enjoy the update!

 


  • Author
  • Wallflower
  • 1 reply
  • July 21, 2022

Love it!! Thanks!