Hi Team, Hope you're all doing well! I’m working...
# gooddata-cloud
t
Hi Team, Hope you're all doing well! I’m working on creating a hierarchy field (e.g., Product Group >> Product Category >> Product Description) to use as rows in a table. Ideally, I’d like users to be able to expand and collapse these hierarchical levels, quite similar to how it works in an Excel Pivot Table. For example, the table would initially show just the Product Group and its metrics, and users could then click to expand and see more detailed breakdowns. So far, I’ve only found this online reference: GoodData Drill Down but it opens a new window and only drills down into one parent item at a time, which may not meet our needs. Please let me know if my question is clear, and do you have any solutions. Thanks in advance!
j
Hello, Fully expandable/collapsible hierarchies like in Excel Pivot Tables aren’t currently supported in GoodData dashboards. As you've correctly mentioned - the closest option is Drill Down - which behaves bit differently. Theoretically, something similar could be built on top of our APIs or React SDK if you’re embedding dashboards, but that would require a custom implementation on your side. If this is an important use case, we can also submit product feedback to our team on your behalf.
t
Hi Julius! Thanks for your response, understood the situation. I will try to explore a bit
Btw, do you have an example screenshot/recording about "something similar could be built on top of our APIs or React SDK"? I want to see what's the result looks like
j
Unfortunately, we don’t have an example screenshot or demo available for this specific kind of custom hierarchy implementation. I just wanted to highlight that our UI SDK and APIs are quite flexible, so with adequate technical skills on your side (e.g., using React and our SDK), it would be possible to implement custom behaviors like expandable/collapsible hierarchies when embedding dashboards. That said, this would require development effort on your end, as it’s not something supported out of the box. Also, if this is a key use case for your team, we’d be happy to submit product feedback to our product team on your behalf.