In this section: |
Key Dashboard Controls:
You can customize toolbars and place them anywhere on the screen. If you build new toolbars, they are saved when you exit WebFOCUS Visual Discovery AE and automatically displayed when you open WebFOCUS Visual Discovery AE. For more information about toolbars, click Help, Topics, and click Toolbars.
To select data, left click and sweep your mouse over what you see on charts. The selection is then seen as colored, with the unselected data as grey. Most of the charts have brushups which will state the % selected. The selected and unselected data will always total to all included (aka non-excluded) data.
When you click on a toolbar button, an action is executed. To see a description of the toolbar, hover the cursor over the button. The Key functions on the Selection Toolbar are:
Toolbar Button |
Description |
---|---|
|
Exclude Unselected. Removes unselected elements from the data view. These items are logically removed and will not show in any of the charts until they are restored. |
|
Exclude Selected. Removes selected elements from the data view. |
|
Restore Excluded. Restores and redisplays all excluded elements. Prior selection state is not changed. |
|
Select All. Use this function to select all data that is not excluded. |
|
Toggle Selection. Use this function to switch between selected and unselected data. |
|
Undo. This function allows you to remove a single action (by selecting this function once) or several actions (by repeatedly selecting this function). Note: This function may be slow or inoperative with large data sets, depending on computer memory. |
|
Redo. This function allows you to re-institute a single action (by selecting the function once) or several actions (by repeatedly selecting this function). Note: This function may be slow or inoperative with large data sets, depending on computer memory. |
Selection mode controls determine how the mouse interacts with the data when you sweep over or click on a chart. The key functions on the Selection Mode Toolbar are:
Toolbar Button |
Description |
---|---|
|
Rectangular Selector. Default Setting. To use the rectangular selector, place the cursor in the area to be captured and drag the mouse while holding down the left mouse button. A rectangular selection box appears around the data that you have selected. |
|
Circular Selector. To use the circular selector, place the cursor in the area to be captured and drag the mouse while holding down the left mouse button. A circular selection area appears around the data that you have selected. |
|
Lasso Selector. Use this tool to select data by creating freehand selection borders around the data. |
|
Replace Selection Mode. Default Setting. The data that you select using this tool replaces previously-selected data. |
|
Add Selection Mode. Use this function to add data to an existing selection. |
|
Subtract Selection Mode. Use this function to remove data from an existing selection. |
|
Intersect Selection Mode. Use this function to select the “intersection” of two fields. This is essentially an “and” function. |
Now that the data you selected is displayed in a page, you can analyze the information to find answers to your business questions.
One of the strengths of WebFOCUS Visual Discovery AE is the ability to select what you see on charts in projects. We call that a selection. A selection on one chart in a project is propagated to all the other charts across all the other pages in a project. This happens in simple one table projects, as well as across charts attached to multiple linked tables in a more complex project. As selections are made, underlying data can be in one of 4 states: Included and Selected (all in), All Included but some Unselected, Excluded, Filtered:
The counts chart is a great way to get a quick view of what's selected, and what's not. The first line (total count) counts all rows in the table whether included, excluded, selected, or unselected.
Note: The counts chart can also show unique counts, sums, averages, etc. The second line shows what is selected, the third line what is included but not selected, and the fourth line shows what is excluded (both by filtering and excluding.
All charts on all pages update instantly based on the selection.
In the page above, only those individuals who are Married are now the colored portions of the bars in the Ethnicity, Gender, In Reunion, and Next Reunion charts.
What does it mean to have selected and unselected data? When you have both selected and unselected data you are able to see the percentage of the selected data to the whole available (= non-excluded) population. In the example, below we see that 70.3% of the available population are Married, you can also see that 91.5% of the Unknown Ethnicity are Married, which is a much higher % than the larger White, Non-Hispanic group. Then you can add in unselected data, intersect with other selected data, or subtract other selected data.
When you add more data, the other charts in the project will adjust to reflect the selection that has been made. In this case, all charts include the Married and Single population.
Notice in the Subtract Select Mode, when selecting the Single bar in the Marital Status chart, the Single bar goes grey as that population is now unselected.
Use the top tool bar to exclude entities and then refresh the charts to show all attributes associated with the selected entities. For example, suppose you have a data set that includes geographical information, such as the State a population of individuals lives in. They may have a primary address in Illinois and a secondary or seasonal address in another state. Now let’s assume you want to exclude all those individuals that do not have an address in the state of Illinois. When you exclude from the Selection table, all those individuals that have an address outside of Illinois will be excluded. However, you will still show a population in your bar chart that includes other states. The reason for this is that all those individuals who have a Primary address in Illinois may have a secondary or seasonal address in another state and the bars for those other states remained and were not excluded. For more information, see the image below.
In this case there are 67 individuals living in Illinois. By excluding the unselected from the Primary or Core table by using the “Exclude Unselected” chart in the tool bar, all those individuals outside of the 67 that live in Illinois have been excluded. However, some of those remaining individuals have seasonal or secondary addresses in other states and those records were returned because they still pertain to the 67 individuals that live in Illinois. What is excluded first are individuals, and then all addresses are updated for those individuals.
In this case because the exclusion was executed locally, all those addresses that existed outside of Illinois were excluded. This is because the exclusion occurred FIRST in the table that included the addresses, not the table that included the individuals.
Filters are a mechanism for specifying a subset of the data from a data source that is available in an analysis session. An easy way to look at filters is as a starting point before your analysis. Suppose you have a data set of individuals and decide from the outset that you want to exclude all the males from the data set before starting your analysis. If your project has a text filter set to Gender you can remove all the males from your project by deselecting Male in the text filter box. See the following image. Notice that with both males and females selected there are 188,238 individuals represented in the data set.
Note that when the Males are deselected from the text filter, the counts of individuals in the data set changes from 188,238 to 111,358 and the counts also show that 76,880 individuals (males) have been excluded from the data set. For more information, see the following image.
It is important to note that the only way to bring back the data that has been excluded due to a text filter is to reselect the filter and return the data to its original state. In this case, to bring back all of the males, you must reselect the Male box in the text filter.
WebFOCUS |