Question

Avoid creating empty rows

  • 24 January 2023
  • 0 replies
  • 256 views

Userlevel 1
Badge +1
  • Seasoned Pigmenteer
  • 13 replies

I have a boolean metric with three dimensions: Position, Version and Month.
 

Position Version Q1 Q2 Q3 Q4
001 Forecast ☑️ ☑️ ☑️ ☑️
001 Plan ☑️ ☑️ ☑️  
002 Forecast ☑️ ☑️ ☑️ ☑️


Positions can be a part of different teams over time. I have another metric, *Position Mapping* which is of type Team with the same dimensions as the boolean.

 

Position Version Q1 Q2 Q3 Q4
001 Forecast Team A Team A Team A Team A
001 Plan Team A Team B Team B  
002 Forecast Team X Team X Team Y Team Y

 

Now I want to add the Team dimension into the first metric. I have tried doing it like this:
‘My boolean’ [by: → ‘Position Mapping’]

Team Position Version Q1 Q2 Q3 Q4
Team A 001 Forecast ☑️ ☑️ ☑️ ☑️
Team A 001 Plan ☑️      
Team B 001 Plan   ☑️ ☑️  
Team X 002 Forecast ☑️ ☑️    
Team Y 002 Forecast     ☑️ ☑️

 


This achieves the goal except for one thing. When I only hide empty columns it still shows all the combinations of Position, Version and Team as empty rows. The original metric didn’t.

How do I map the Team dimension into the metric so that it only shows where applicable. The reason for asking is that I have a table with seven different metrics and I want to show them in the table (using page filters) even when the metric is empty. 


0 replies

Be the first to reply!

Reply