Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
The "Tree List" opt...
 
Notifications
Clear all

The "Tree List" option under properties encompasses which different aspects?

3 Posts
2 Users
0 Likes
153 Views
Abhishek
(@abhishek)
Eminent Member
Joined: 11 months ago
Posts: 11
Topic starter  

I am working on creating a Tree List chart. How do I align it and add aggregates at each level? 


   
Quote
ankit.pradhan
(@ankit-pradhan)
Eminent Member
Joined: 2 years ago
Posts: 20
 

Step 1: On the top right corner of the page, click on visualization under properties. Click on the Tree List icon under properties. 

Step 2: Drag and drop the required columns in dimension and measure. The data is represented in the form of a Tree List Chart.

Step 3: Locate the “Tree List” option under properties. Here, you can select the dimensions that you want to be in a separate column. 

Step 4: There are several other options that are available under tree list like “Collapse Column by Default, Parent Column Collapse, Hide Aggregate on Collapse, Disable Parent Collapse”. 

Step 5: You can toggle the collapse columns on default option. What this does is that all the columns of the tree list remain in a collapsed position. 

Step 6: If you want to show only the parent row of the tree list, then click on the parent column collapse toggle.

Step 7: You can also hide the aggregate total of the child that is displayed next to the parent. Toggle the Hide Aggregate on Collapse toggle. 

Step 8: To show the aggregate total next to the child, toggle the Hide Aggregate on Collapse toggle off. 

Note: The collapsed column aggregate toggle needs to be toggled on for Step 7 & Step 8 to give results.


   
ReplyQuote
ankit.pradhan
(@ankit-pradhan)
Eminent Member
Joined: 2 years ago
Posts: 20
 

If you do not want to close/ open the parent accordion and wish to freeze it, click on the Disable Parent Collapse toggle. The accordion will not be clickable.


   
ReplyQuote
Share: