Collapsible Tree Node with Zoom&Drag

Download: Collapsible Tree Node Plugin

Version: 1.2

Introduction

This article explains how to install and configure the Collapsible Tree Node widget as seen below.

Tree data structures and representations are sometimes essential to show hierarchical organizations of data and concepts.

Purpose/Benefits

It allows users to visualize hierarchical data set very easily with the ability to drill into the hierarchy up or down.

How to Install and Configure the plugin

Step 1 - Add The Plugin

Download the attachment and unzip the contents into your C:\Program Files\Sisense\PrismWeb\plugins\ folder. If you are using version 7.2 and higher unzip the contents into your C:\Program Files\Sisense\app\plugins\ folder. If the plugins folder doesn't exist, just create it. After those files have been unzipped there, you may also have to restart the web server. Now, when you create a new widget the "Collapsible Tree" widget should show up in the list of options.

Step 2 - Create the "Collapsible Tree" Widget

On your dashboard, click the Create Widget button and select Advanced Configuration. Next, select the "Collapsible Tree" widget from the drop down list. For this you will need to specify one or more Categories and a Value field. For the below example, we have added the following Categories: Full Name, Region Description, Category Name, Product Name and "Value" from the "Total Sales" field.

As a result the above widget will display a tree structure starting at a high level from Full Name and will allow to drill down into the lowest level which is Product Name. You can rearrange the categories order to change the Tree drill path.

The widget also offers the following design options:

Enable Zoom & Drag - toggle on/off the ability to zoom and drag
Auto collapse Unselected - toggle on/off the feature to auto collapse all tree nodes except the selected one
Highlight Path - toggle on/off the ability to display the drill path from the selected node all the way up to the root node
Show Tooltip - toggle on/off showing tooltips when mouse is over a specific node
Orientation - this will allow designer to specify the orientation of the Tree object (Left-to-Right, Top-to-Bottom, Bottom-to-Top, Right-to-Left)

The widget also allow the user to format the Text & Color of the "Value" measure field.

References/Notes

Tree Structure, Wikipedia

Release Notes

20-Jun-2017 - Initial release
20-Jun-2017 - Add the ability to format the color of the last node of the tree
21-Feb-2018 - Fix styler control for version 7.x

Jim Thomas June 22, 2017 20:06

Ronen,

Very neat. The ability to do conditional formatting of nodes based on the value to highlight the outliers or issues would be fantastic.

Regards, Jim

Ronen Avidor June 22, 2017 21:00

Hi Jim,

Added the ability to setup color formatting (including conditional), This is done using the value from the last node.

Best,

Ronen

Jim Thomas June 22, 2017 21:18

An improvement. Even better would be the basing on the values of the intermediate nodes at each level as well so I would know which branch to expand to see identify the issues. I'm experimenting with using for downtime analysis: which modules in a turbine are my major sources of downtime using the Equipment Breakdown Structure.

Jim Belden December 19, 2017 19:08

The design options don't seem to work. I am on version 7.0.

Shikha Garg May 23, 2018 18:59 (Edited May 23, 2018 18:59)

Is it possible to keep my tree fully open with all levels of branches all the time so that user can have one click information about everything ?

Admin June 18, 2018 13:31 (Edited June 18, 2018 13:32)

Hi, would it be possible to select items in the widget so I select some departments and filters are created for the dashboard?

Collapsible Tree Node with Zoom&Drag

Comments

Didn't find what you were looking for?