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:
A | A.1
C | C.1
C | C.2
C | C.3
Each level of the hierarchy is a separate column
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
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
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.