Unlike the standard Pie Chart based on Lookup Value which shows you the break-up of objects based on a drop-down property, the Recursive Pie Chart allows you to show a top-level chart which sums the values of properties of Associated Objects (or Intersection Objects), and then allows users to click those items to view a second chart showing all the objects associated to the selected object.
You can include multiple levels of associations in one chart, so users can drill down from one to another.
Step 1 |
Step 2 |
Step 3 |
---|
|
The Recursive Pie Chart requires at least one Association Type to work, as well as a Whole Number or Decimal Number property on the Associated Object - or Intersection Object. |
---|
Why and how should you use one?
You should use a Recursive Pie Chart when you want to get an overview of some underlying data by way of an Association. Think of it as a visual representation of the sum of a numeric property on associated objects.
For example, you have some Technology objects, each with a Cost property, and in your model, Technologies are associated to Organization objects which are used to represent Departments in your business.
In this example you could use the Recursive Pie Chart to show Technology Cost per Department. The chart is configured to show Organization objects - but the size of each piece is based on the total (summed) Cost of the Technology objects associated to each one.
While the above example examines one level of association, you can extend this basic functionality to include more steps, by adding additional Association Types, allowing you to visualize the data of objects Indirectly Associated to the higher-level objects. The result is to have more click-through pie charts, one focusing on a different Object Type in the chain.
For example, if your Organization owns a number of different companies, your data could consist of:
Company objects used to define companies in the group
Country objects used to define countries where you have offices
Department objects used to define departments within the company
Technology objects used to define server machines.
The Technology objects have a Cost property to specify the running costs per year for each machine.
Your model has Association Types linking these Object Types together - in the following path: Company > Country > Department > Technology
You could then use a Recursive Pie Chart to show the summed costs of server machines (Technologies) per Company, then after clicking through by Country, and then by Department, in one interactive chart.
See Use multiple Association Types to visualize Indirect Associations below for details.
|
You can sum properties of the Intersection Object instead of the Associated Object if you wish. |
---|
Where and when can you use one?
Use the table below to see where you can use a Recursive Pie Chart:
Page Type |
Parent node |
Tabs |
Number on page |
Editable |
---|---|---|---|---|
Index Page |
Object Type node |
Yes - optional |
1 or more |
No |
Object Page |
Association Type node |
Yes - mandatory |
1 or more |
No |
What would you like to do?
Add a Recursive Pie Chart to your page
|
These instructions lead you to create a basic Recursive Pie Chart, which results in a pie chart showing instances of the first object, sized by the sum of a property of the associated objects, then a second pie chart users can drill down to which shows instances of the associated objects for just one of the top-level objects. By following these instructions you could create the Organization to Technology (Cost) example described above. The parent node mentioned in the instructions is the Object Type node for an Index Page - optionally within a Tab - or is the Association Type node within a Tab on an Object Page. |
---|
Select the parent node - Object Type node for Index Pages, Association Type node for Object Pages - and use the Filter Properties area to apply any filtering
Switch the Layout node beneath the parent node to Empty
To do this: Right-click the Layout node and choose Switch Layout > CW > Empty
Add the Recursive Pie Chart behavior to the Layout node
To do this: Right-click the Layout node and choose Add Behaviors > Pie Charts > Pie Chart (Recursive)
A Pie Chart (Recursive) node is added
Add an Association to the parent node - choosing the Associated Object Type which has the property you want to sum
To do this: Right-click the parent node and choose New Association > [object-type] > [association-type]
A new Association Type node is added
Select the Association Type node and in the Selected Properties area, tick the property you want to sum on the chart
Select the Pie Chart (Recursive) node and configure the following settings:
Use the Node Name to set the name of the node as it appears in the tree - you only need to edit this if you are using multiple Recursive Pie Charts
Use Leaf Object Type Scriptname to specify the Scriptname of the Associated Object Type - for example, 'technology'
Always use lower case when referring to Scriptnames
Use Property Scriptname to Sum to enter the Scriptname of the property on the Associated Object you want to sum
Use the Where is the Property to sum drop-down to choose whether you want to sum a property of the Associated Object, or a property of the Intersection Object
|
See the separate instructions below for more details on using the Intersection Object. |
---|
Use Property Unit to specify the text to be displayed on the chart for the sum value
Use Intersection Object Type Scriptname to specify the Scriptname of the Associated Object Type
Use the same Scriptname as for the Leaf Object Type Scriptname
Save your Site.
Use a property of the Intersection Object for the sum
You can configure your Recursive Pie Chart to sum the values of Intersection Objects rather than values of the Associated Objects themselves.
|
Just as with values for Associated Objects, the properties must be Whole Number or Decimal Number. |
---|
The instructions for creating a Recursive Pie Chart in this way is exactly the same as for referencing an Associated Object, with the following exceptions:
Set the Where is the Property to sum drop-down to 'On the intersection before'
Use Property Scriptname to Sum to enter the Scriptname of the property on the Intersection Object you want to sum
Use Intersection Object Type Scriptname to specify the Scriptname of the Intersection Object Type.
Use multiple Association Types to visualize Indirect Associations
If you want to add more steps in your Recursive Pie Chart using multiple levels of associations, you should follow the points below:
Nest additional Association Type nodes beneath each other - add the next Association Type by right-clicking on the Association Type node you want to nest beneath
On the Recursive Pie Chart node the settings should reference the object at the end of the chain - in the example case, the Technology.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center