Refining Your View
A number of controls are available on Tree, Worksheet and Pivot slides in the top right corner which will allow you to refine the view of the data on the selected slide
The controls are also repeated on each panel of a Multi Slide to enable individual slide refinement
- A. Expand To (level)
- B. Color Control
- C. Color Legend (if colors applied)
- D. Filter
- E. Paging
- G. Export Canvas Content
Other slide types will have reduced options available as levels and color controls are not available on all slide types
Expand to Levels
Reduces / expands nodes on the Tree and Worksheet visualizations to the specified level
color control
You can color nodes in visualizations by a single color or split by a selected property either using a multi palette for any property types or heatmap for number properties
To apply color to nodes select the color by icon
You can select either:
- A. Fixed
- B. Property
- C. Heatmap
Fixed
Fixed color allows you to select any color or to use a # hex code to use specific colors by selecting the Show More option
This will open an extended color picker area with the option to enter a color hex code directly
The color palette shown when initially opening the color panel, will be the ones selected on the standard palette in the settings menu
Property
You can also select property to color based on the value of a selected property
When you use this function you first need to select a property using the drop-down list or the search function
There is also a Reverse color option, which is located at the bottom left of the Color by menu. This allows you to reverse the color range of the palette you have chosen
Multi-color Palettes
There are a range of multi-color palettes to choose from, allowing you to highlight your data in the most effective way
Sequential
Color palette based primarily on a single base color, with the option of having up to three base colors. There are multiple variations of shades of the base colors, which blend well in visualizations. Great for visualizing measures in a range
Diverging
Color palette based primarily on two contrasting base colors, with multiple shade variations of the base color. Also, good for visualizing measures especially with high / low ranges
Categorical
A range of palettes with contrasting colors which are great when coloring by dimensions with up to 30 buckets. Any custom palettes will also appear here
Heatmap
The heatmap option enables the coloring of a visualization based on a number property
It may be applied either:
- A. As a single color where larger numbers appear as a darker shade of selected color
- B. Using a Palette as the heatmap with larger and smaller numbers at either end of the palette
Color property values a specific color
To view a video showing how to color property values a specific color click the thumbnail to open the video in a new browser tab
Color Legend
When you select multi-color, you get an additional Color Legend option
The Color Legend shows you the distribution of your selected property by the color palette you have chosen
Right-clicking on any bucket within the color legend will open the additional menu to enable the nodes in the bucket to be added and removed from selections and filters
Filters
Filters enable the data shown on a slide to be limited to a particular set of data
Note: When you apply a filter, you are only applying that filter to the slide you have currently selected, although it is possible to copy and paste filters from one slide to another See 8.2.4 Copy & Paste Filters for more details
To view a video on adding and using Filters click the thumbnail to open the video in a new browser tab
To open the filter panel select the filter icon
From the Filter panel you can then select and sort the Properties you want to display
To do this you need to:
- Select the properties you want to display. Those properties will appear to the right of the Select Properties menu
- Select the property buckets you want to filter those properties by
- You can also sort the order of the property nodes using the More Options Menu
- Node count can be displayed either as a value or percentage
You can view summary details about your filter selections using the statistics menu button at the bottom of the filter control panel
- A. For dimension properties the options are limited to:
- Count (CNT) The count of non-blank nodes in the grouped data
- Bucket Count (CNTD) Provides a distinct count of property values for nodes in grouped data
- B. For measure properties you can choose from the following options:
- Average (AVG) The average of the grouped data values
- Sum (SUM) The sum of the grouped data values
- Minimum (MIN) The lowest value in the grouped data
- Maximum (MAX) The highest value in the grouped data
- Range (RNG) The delta value between min and max in the grouped data
- Count (CNT) The count of non-blank nodes in the grouped data
- Bucket Count (CNTD) Provides a distinct count of property values for nodes in grouped data
When you add properties to the filter properties you will see:
- A teal colored filter icon on the slide you have added them to when then slide is selected
- The filter icon will appear grey when applied to a slide that is no longer selected
A summary of the filters applied will also be displayed at the top of the slide
Note: The count (CNT) of nodes selected in the filter will exclude any nodes with a blank value for the selected property
Filter Across Links
When working with linked datasets it is also possible to filter the data in the linked datasets across the links
The join control, shown on the filter panel whenever you are using a linked dataset, allows you to control how your filter in one dataset impacts the links and linked to datasets
The join control has three sections
- A. The From dataset
- B. The Link dataset
- C. The To dataset
Clicking the icons between the sections enable you to create joins between the different datasets
No join: the datasets are filtered independently. A filter on one dataset will not impact another
Left join: the dataset appearing on the left and the links dataset are joined together. Filtering on either will also filter the other joined dataset
Right join: the dataset appearing on the right and the links dataset are joined together. Filtering on either will also filter the other joined dataset
Inner join: all three datasets are joined together. Filtering on one dataset will also filter on the other two datasets
With the join control set to inner join, the effect of selecting a bucket in one dataset in the filter can be seen in the linked datasets on the data in the filter panel
In this example selecting the 100k to 150k bucket in the people dataset shows how the 17 nodes in this bucket are distributed in the departments in the positions dataset
To view a video on Filtering Across Linked datasets click the thumbnail to open the video in a new browser tab
Paging
Paging is a method used to split data presented on a slide into discrete pages using a dimension or measure
Selecting the paging control will open a selection panel with the dataset properties listed
When adding dimensions or measures you can:
- Scroll through the list and select properties by clicking them
- Use the search function at the top of the pop-up to find the required dimension or measure
Clicking outside the pop-up window will close the paging dialogue box
Once you have selected paging properties, they appear at the top of the canvas
You can either:
- A. Page through using the left / right arrows
- B. Click on the Property to select the Property you want