Is there a way to create/view dimension hierarchy in single column in table?

I have unbalanced hierarchy to display in looker. Want to display that in table. Is there any option to display unbalanced hierarchy?

1 5 859
5 REPLIES 5

Dawid
Participant V

You wold have to flatten your hierarchy to fit it into a table format. Like:

  1. A
    1. A.1
  2. B
  3. C
    1. C.1
    2. C.2
    3. C.3

Would become

A | A.1

B | 

C | C.1

C | C.2

C | C.3

Each level of the hierarchy is a separate column

Dawid -

Thanks for your reply. I have done this but I have too many null columns because of unbalanced hierarchy with Fact. Is there a better way to visualize all hierarchy in single column?

cf5c4de0-570b-490e-b28d-005094e46c9c.png

Dawid
Participant V

What is your desired output here?

This is my desired output

Hierarchy Fact
A 123
B 234
   B2 34
      B3 23
          B4 12
C 345
  C2 345

Dawid
Participant V

You’d have to create some kind of number in SQL that would actually order it this way. Perhaps then you could use liquid and HTML parameter to insert number of spaces in front. But since I don’t have data like this, I can’t really test such solution, so this is just from the top of my head

Top Labels in this Space
Top Solution Authors