Home Download Forums Support  

Venn View

Venn View

Visualise intersections & overlaps among defined data queries/subsets

The Venn View is based on the familiar Venn diagram. This view enables visualisation and filtering on overlaps between up to 5 different named query data sets or subsets, which must first be pre-defined as Named Queries. Notice that the number of records (or other measure specified in Value/Function) not included in any selected set/subset is displayed upper left after the heading 'Outside'. In the HR example below right, the median age of all the staff not included in one of the selected subsets is 42.

 

 

Venn View Toolbar

 

Venn View Toolbar View picker, Data Subset selector, Aggregate options drop-down and the show Details all function the same as they do in all the views. View Toolbar options unique to the Venn View include the upper-pane View tools options, the Value: menu to specify the values to be used, and the Sets: menu to specify the existing Named Query data subsets (maximum 5) for which Venn shapes will be displayed.

Venn View Tools

Venn View > View tools

Preserve aspect - (default) locks the shape of each circle to remain a circle. Unticking this option allows the Venn shapes to distort to reflect the intersections.

Paint outside space - colours the background outside the Venn shapes, which can improve visual impact especially if there are unselected records being displayed upper left under the heading 'Outside'

Play sounds - try it, you might like it

Show zero counts - displays set names and intersection counts even if zero.

 

The rest of the options in the lower panes are common to the View tools menus for all views and are documented here.

 

Venn View Value/Function:

 

Venn View > Value: {Function}

Use this menu to select the values for which the counts are displayed inside the Venn shape representing each data set/subset. Notice that text columns are not shown. 

Counts only are available for category values. If you select numeric value, an additional Function menu appears allowing you to specify the calculation applied. (see example of average age above right)

 

Find: shows subsets of field (column) names to shorten the list

Sort: orders the field (column) names to speed selection

Venn View Sets:

Venn View > Sets: (number of sets selected)

All of the Named Queries which define subsets are available here for selection and display as Venn shapes, up to a limit of 5. Drag the hands at right upwards or downwards to re-order the list.

 

Home Knowledge Base Reference Guide to Views Venn View