Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Optional Hierarchy

Hello!

I am wondering if there is any way to have an "optional" tier in a hierarchy...to whit:

 

My "normal" scenario is Division > Team > [stats]

I have a couple of divisions that need to be Division > Group > Team > [stats]

 

Am I able to manage that in a matrix? Adding the field in doesn't work the way I want--it has blank values. I can't find anything online (but I may be searching for the concept incorrectly).

 

Thanks!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    You can use bookmark and button to display the hierarchy:

    e.g 

    If this cannot meet your requirement, can you provide some sample data or pictures?

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you for the sample file! It is not quite what I need, though.

       

      Here's a representation of my sample data. I have a file I can send, but apparently I can't figure out how to attach the file. As you can see, I have a list of people, all assigned to teams. Some of those teams have "sub teams".

       

      My goal would be that my single Matrix could show all teams in a single view, such as:

      Team A > Addie, Albert, Bob

      Team B > Team 1 > Bill, Murray, Phil

      Team B > Team 2 > Rob, Angela

      Team C > Raquel, Max

       

      Hopefully this makes sense. My visualization right now just has:

      Team A > [blank] > Addie, Albert, Bob

       

      I know *why* the [blank] is showing up (it's an empty field in that column) but I'm not sure how to make that empty field not be shown when it's blank, and shown when it is NOT blank.