Forum Discussion
Visualizing data with hierarchy
Hi all,
I have ticket data with hierarchy taht I would like to show in a table type of format with drill down capability in a way that each row would show the details of that particular item, not any kind fo summary.
The source data is like
| ID | Title | Team | Sprint | Hierarchy |
| 1 | Title1 | Team1 | 1 | |
| 2 | Title2 | Team2 | Sprint2 | 1|2 |
| 3 | Title3 | Team1 | 1|3 | |
| 4 | Title4 | Team2 | Sprint1 | 1|3|4 |
| 5 | Title5 | Team1 | Sprint2 | 1|3|5 |
| 6 | Title6 | Team6 | Sprint1 | 1|3|6 |
And would like to present it something like this
I have tried to use Matrix but it summarizes the data for thie top level in a way that the top level rows are not showing their own data but instead the data from the first sub item.
Any ideas how to do that with Matrix or any other visual I should use?
1 Reply
Matrix should work, worst case you'd need some custom measure for the value well.
What you cannot do is have the ID column in the front.
