I have unbalanced hierarchy to display in looker. Want to display that in table. Is there any option to display unbalanced hierarchy?
You wold have to flatten your hierarchy to fit it into a table format. Like:
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?
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 |
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