Topics: |
Visualizations centralize information by providing different views of data that are pertinent to a particular objective. For example, reviewing trends or fluctuations in data over a period of time or within a region. A visualization provides you with a quick glance of information on a single screen.
Visualizations support the use of different types of charts, maps, and grids. For example, you may want to use a bar, pie, and line chart to show different views of the same data. Alternatively, you may want to offset a particular visual by showing other types of related data that employ a different type of visual. You can also add a text cell to your visualization to provide explanatory text or information that other users can reference.
Visualizations allow you to monitor changes in data. They also serve to provide information in real-time, based on changes in underlying data or other components. A visualization can be updated, changed, or revised at any time to account for shifts in data needs.
Topics: How to: |
You can create charts, maps, and grids to visually represent your data. You can add multiple visuals to the canvas to create a complete visualization.
The default visual is a bar stacked chart. You can use the Change option in the Visual group on the Home tab to change the visual type.
The following visual is a matrix marker chart that shows sales data for a range of electronic products.
You can have multiple file types opened at once. To create a visualization:
or
Click the Application Main Menu button, and click New.
The InfoAssist+ splash screen displays.
InfoAssist+ switches to visualization mode.
You can create a visual using the default chart type, which is a stacked bar chart. You can add your data to this chart and then change the chart type, or you can change the chart type prior to making your data selections.
Once you have started exploring your data, you can switch between the different types to obtain the graphical image that you wish to display.
You change the visual type from the Home tab.
Note: The Change icon updates depending on the chart, map, or grid that you select from the Select a Visual menu. By default, the Change icon displays a stacked bar chart.
The Select a Visual menu displays.
Your canvas refreshes and displays the visual that you selected.
Note: Depending on the type of visual that you select, you may need to select additional or different data fields.
Topics: |
|
It is important that you select a chart, grid, or map that appropriately displays a meaningful view of your data. InfoAssist+ provides a library of visuals.
You can select a visual type from the Select a Visual menu, on the Home tab, in the Visual group. The following table describes the types of charts available.
Icon |
Visual Type |
Description |
---|---|---|
|
Grid |
Grids provide a tabular view of data. They allow you to review data in a row and column format, similar to a printed report. |
|
Bar chart |
Bar charts plot numerical data by displaying rectangular blocks against a scale (numbers or variable measure fields that appear along the axis). |
|
Stacked bar chart |
A stacked bar chart is the default visual. |
|
Absolute line chart |
Line charts allow you to trace the evolution of a data point by working backwards or interpolating. Highs and lows, rapid or slow movement, or a tendency towards stability are all types of trends well suited for a line chart. |
|
Area chart |
Area charts analyze trends over time and look for differences in values. |
|
Stacked area chart |
Stacked area charts allow you to stack data on top of each other. |
|
Pie chart |
Pie charts are circular charts that represent parts of a whole. A pie chart emphasizes where your data fits, in relation to the other components in the pie. |
|
Ring pie chart |
Ring pie charts are useful when you want to review the value of each segment, which represents the measure value for the selected dimension, as it relates to the total for the selected measure. |
|
Scatter Plot |
Scatter charts enable you to plot data using variable scales on both axes. When you use a scatter chart, the data is plotted with a hollow marker, so that you can visualize the density of individual data values around particular points, or discern patterns in the data. |
|
Bubble chart |
Bubble charts can have two column fields representing X and Y data values, or have three column fields representing X, Y, and Z data values. The third variable (Z) represents size. The size of each bubble is used to show the relative importance of the data. |
|
Matrix Marker chart |
Matrix marker charts are useful for analyzing one or two measures against a crosstab of two categorical dimensions. The result is a color-scaled matrix chart that shows categorized trends. |
|
Treemap |
Treemaps are used to display large amounts of hierarchically structured data. Using a set of nested rectangles to illustrate data relationships, sections of a treemap represent branches of a tree. |
|
Gauge |
Gauges are used to display the value of a measure. In particular, circular gauges are used to represent a single data value within a given spectrum. You can create a single circular gauge for a measure or a matrix circular gauge, which shows the value of the selected measure across different dimensions, such as product category or yearly sales. |
|
Choropleth map |
A geographically-based heat map. It is useful for visualizing location-based data, trends, and distributions across a geographic area. |
|
Proportional symbol map |
A technique that uses symbols of different sizes to represent data associated with different areas or locations within the map. |
|
Heatmap |
A heatmap is a graphical representation of data where the individual values that comprise a matrix are represented as colors. Using radiant hues, you can track the intensity of a data relationship using the colors defined in the legend. |
Note: When new data is added to a bar, line, area, pie, scatter, bubble, gauge, or treemap chart, the chart will morph and rebuild, revealing the new values in a smooth transition.
Use the topics in this section to select and create your visuals.
Grids provide a tabular view of data. They allow you to review data in a row and column format, similar to a printed report.
In the following example, we review the Sale Year and Product Category data for the following measure fields:
As you add, edit, or rearrange the fields in your Query field containers, your canvas refreshes.
Bar charts plot numerical data by displaying rectangular blocks against a scale (numbers or variable measure fields that appear along the axis). The length of a bar corresponds to a value or amount. You can clearly compare data series (fields) by the relative heights of the bars. Use a bar chart to display the distribution of numerical data. You can create horizontal and vertical bar charts.
Note: If you are working with a large dataset, a scroll bar displays under your chart, enabling you to easily scroll through your data from left to right. In visualization mode, scroll bars are automatically enabled, but if you want to disable or re-enable scroll bars, click the Format tab and then click Interactive Options. In the Interactive Options dialog box, select the Auto Enable X-Axis Scrolling check box. If you are working in any other mode, you must enable this functionality.
Use a bar chart when individual values are important. For example, the following image is a basic vertical bar chart that compares the individual products sold to the total amount in sales for each product. A retailer would find it important to know which pieces of inventory are selling and how much revenue each item is generating for the company.
A horizontal bar chart becomes useful when you want to emphasize a ranking relationship in descending order, or the X-axis labels are too long to fit legibly side-by-side. For example, the following image is a basic horizontal bar chart that ranks which products are generating the most revenue for the retailer.
Note: You can swap the orientation of your data in a bar chart. To do so, on the Home tab, in the Visual group, click Swap.
Note: You can also double-click a data field to add it to your Query field containers.
The bar chart displays on the canvas. You can add additional data fields for comparative purposes. You can also view underlying data by hovering over any particular point on the bar chart.
The bar stacked visual is the default visual.
Note: You can also double-click a data field to add it to your Query field containers.
The stacked bar chart displays on the canvas. You can add additional data fields for comparative purposes. You can also view underlying data by hovering over any particular point on the stacked bar chart.
Line charts allow you to trace the evolution of a data point by working backwards or interpolating. Highs and lows, rapid or slow movement, or a tendency towards stability are all types of trends well suited for a line chart.
You can also plot line charts with two or more scales to present a comparison of the same value, or set of values, in different time periods.
Note: If you are working with a large dataset, a scroll bar displays under your chart, enabling you to easily scroll through your data from left to right. In visualization mode, scroll bars are automatically enabled, but if you want to disable or re-enable scroll bars, click the Format tab and then click Interactive Options. In the Interactive Options dialog box, select the Auto Enable X-Axis Scrolling check box. If you are working in any other mode, you must enable this functionality.
Use a line chart when you want to trend data over time, for example, monthly changes in employment figures, or yearly sales of an item in your inventory. The following image is a line visual that shows the gross profit in monthly sales for products.
Note: You can also double-click a data field to add it to your Query field containers.
To add insight, you can drag a data field to the color Query field container. This displays the values for this field using color.
The line chart displays on the canvas. You can add additional data fields for comparative purposes. You can also view underlying data by hovering over any particular point on the line chart.
Area charts analyze trends over time and look for differences in values by using the see-thru nature of the area fills. Stacked area charts allow you to stack data on top of each other. Stacking allows you to highlight the relationship between data series, showing how some data series approach a second series.
Note: If you are working with a large dataset, a scroll bar displays under your chart, enabling you to easily scroll through your data from left to right. In visualization mode, scroll bars are automatically enabled, but if you want to disable or re-enable scroll bars, click the Format tab and then click Interactive Options. In the Interactive Options dialog box, select the Auto Enable X-Axis Scrolling check box. If you are working in any other mode, you must enable this functionality.
Use an area chart when you want to distinguish the data more dramatically by highlighting volume with color. For example, the following image is a basic area chart that depicts the yearly gross profit for various electronic products.
Note: You can also double-click a data field to add it to your Query field containers.
The area chart displays on the canvas. You can add additional data fields for comparative purposes. You can also view underlying data by hovering over any particular point on the area chart.
Note: You can also double-click a data field to add it to your Query field containers.
The stacked area chart displays on the canvas. You can add additional data fields for comparative purposes. You can also view underlying data by hovering over any particular point on the stacked area chart.
Pie charts are circular charts that represent parts of a whole. A pie chart emphasizes where your data fits, in relation to the other components in the pie. Pie charts work best when there are a limited number of slices (for example, less than 10) and the slices are all of a sufficient value as to reveal their fill color inside their wedge.
Use a pie chart when you have segments of data that you want to display as a whole. For example, the following image is a pie chart that shows the proportions of various electronic products based on the quarterly revenue.
You can add one or more measures to the Measure field container. Each measure will be used to create a separate, unique pie chart, to which you can add a measure or dimension to the Color field container to add color to your chart.
Note: When working with pie charts, you can add one measure field to the Color field container. This adds the measure as a By field, and determines how the pie chart is colored. Depending on your measure data, this may result in a large number of pie segments.
Note: You can also double-click a data field to add it to your Query field containers.
The pie chart displays on the canvas. You can add additional data fields for comparative purposes, or to create another pie chart on the same canvas. You can also view underlying data by hovering over any particular point on the pie chart.
Ring pie charts are circular charts that display the total for the selected measure, as well as the individual segments that comprise the ring pie chart. You can hover over each segment to review the underlying data values. This is useful when comparing the measure value for an individual segment against the total for the measure, which displays in the center of the ring pie.
You can add one or more measures to the Measure field container. Each measure will be used to create a separate, unique ring pie chart, to which you can add a measure or dimension to the Color field container to add color to your chart.
Note: The font size of the value label in the middle of the ring is automatically set by the chart engine.
Use a ring pie chart when you want to review the value of each segment, which represents the measure value for the selected dimension, as it relates to the total for the selected measure. The following image is an example of a ring pie chart.
Note: You can also double-click a data field to add it to your Query field containers.
The ring pie chart displays on the canvas. The total for the selected measure displays in the center of the ring pie chart. You can view underlying data by hovering over any of the ring pie chart segments.
Scatter charts enable you to plot data using variable scales on both axes. When you use a scatter chart, the data is plotted with a hollow marker, so that you can visualize the density of individual data values around particular points, or discern patterns in the data. A numeric X axis, or sort field, always yields a scatter chart, by default.
Note: You can specify a non-measure (dimension) data field on the horizontal or vertical axis, or both.
If your chart reveals clouds of points, there is a strong relationship between X and Y values. If data points are scattered, there is a weak relationship, or no relationship.
Adding data fields to the Detail Query field container creates additional BY fields on the scatter chart. For example, the following image shows the results when adding the Product,SubCategory and Model dimension fields to Detail Query field container in a scatter chart which showed gross profit and MSRP data.
Note: You can also double-click a data field to add it to your Query field containers.
The scatter chart displays on the canvas. You can also view underlying data by hovering over any particular point on the scatter chart.
A bubble chart is a chart in which the data points are represented by bubbles. Bubble charts can have two column fields representing X and Y data values, or have three column fields representing X, Y, and Z data values, in that order. The Z variable represents size. The size of each bubble is used to show the relative importance of the data.
When you add a data field to the Size field container, this value is represented as the Z Axis Title in the legend. It displays as an empty Z Axis Title when a size data field is not specified. If you choose to indicate a Z, or size, data value, the data label displays in the legend. A Size Legend also displays, showing the estimated data value for a range of circle sizes. This allows you to estimate the value of the data based on the size of the circle.
Note:
In the following image, a bubble chart is used to show the Manufacturers Suggested Retail Price (MSRP) plotted against Revenue for a variety of electronics products. It also shows the values for Gross Profit, which was specified in the Size field container in the Query pane.
Note: You can also double-click a data field to add it to your Query field containers.
The bubble chart displays on the canvas. You can also view underlying data by hovering over any particular point on the bar chart.
Matrix marker charts are useful for analyzing one or two measures against a crosstab of two categorical dimensions. You can use the Size Query field container for one measure and the Color Query field container for a second measure. The result is a color-scaled matrix chart that shows categorized trends, as shown in the following image.
The matrix marker chart displays.
Treemaps are used to display large amounts of hierarchically structured data. Using a set of nested rectangles to illustrate data relationships, sections of a treemap represent branches of a tree. Each branch is given a rectangle, to which any number of smaller sub-branches can be assigned. The size of each branch is proportional to the summed values of the elements inside the branch.
The following treemap shows the categories of the selected dimension fields, using two data fields to determine the size and color of the treemap segments.
The treemap displays.
Gauges are used to display the value of a measure. In particular, circular gauges are used to represent a single data value within a given spectrum. These gauges have a circular shape. You can create a single circular gauge for a measure or a matrix circular gauge, which shows the value of the selected measure across different dimensions, such as product category or yearly sales. The value of the measure that displays in a circular gauge is determined by the underlying data stored for that measure in the database.
The circular gauge functionality uses only one measure in its presentation. The legend reflects the color of the measure within the circular gauge.
In the following example, we review revenue data for each product category by quarterly sales in a matrix circular gauge chart.
Note: You can also double-click a data field to add it to your Query field containers.
The circular gauge displays on the canvas. You can select additional measure fields for which to include in the tooltip.
A heatmap is a graphical representation of data where the individual values that comprise a matrix are represented as colors. Using radiant hues, you can track the intensity of a data relationship using the colors defined in the legend.
Heatmaps are useful when you are looking for hot spots in your data, or areas of focus or interest, as shown in the following image.
Note: You can optionally populate the Matrix Row and Column fields to increase the segmentation of your heatmap.
The heatmap displays.
Topics: How to: |
A visualization is comprised of one or more visuals, such as charts, maps, or grids and text. You can create different views of your data in a single visualization, and share that visualization with others in your enterprise.
The following image shows a sample visualization. This visualization includes a map, a matrix grid, and a stacked area chart.
This section summarizes the tasks that are available to you when working with visuals. It provides centralized instructional information on performing each task and offers links to the most common topics when working with visuals.
Task |
How To |
---|---|
Change visual |
On the Home tab, in the Visual group, click Change. Note: The Change icon updates depending on the chart, map, or grid that you select from the Select a Visual menu. By default, the Change icon displays a stacked bar chart. Select a chart, map, or grid from the Select a Visual menu. |
Insert new visual |
On the Home tab, in the Visual group, click Insert. Use the default stacked bar chart or click Change to select a different chart, map, or grid from the Select a Visual menu. Note: You can also add additional charts, maps, or grids to a visualization by dragging a data field onto the canvas and placing it using the handles that are available. |
Rearrange visuals |
Drag a visual on top of another visual to activate a shaded area that contains handles, which can be used to indicate placement. |
Copying a visual |
On the canvas, select a visual. On the Home tab, in the Clipboard group, click Copy. Note: You can also press CTRL+C to copy a selected visual. |
Pasting a visual |
Copy a visual. On the Home tab, in the Clipboard group, click Paste. Note: You can also press CTRL+V to paste a copied visual on the canvas. |
Duplicating a visual |
On the canvas, select a visual. On the Home tab in the Clipboard group, click Duplicate. A duplicate visual is created and a sequential number is assigned based on the type of visual. |
Delete visual |
Select a visual. On the Home tab, in the Clipboard group, click Cut. You can click the Close button in the upper-right corner of the current visual. From the Query pane, right-click a visual and click Delete. You can also press the Delete key when a visual is selected. |
Apply Filter |
Drag a dimension field or measure field into the Filter pane to access the filter options that are available. To add filter options for a field that is already in the Query pane, select the field and on the Field tab, in the Filter group, click Filter. |
Add visuals to the storyboard |
Create a visual. On the Home tab, in the Storyboard group, click Add. |
Note:
A text cell opens on the canvas.
Note: You can resize the text cell and use the text formatting options to customize the display of any text that you add, as shown in the following image.
You can also position the text cell in your visualization by dragging the text cell on top of a visual. Use the placement handles to indicate placement of the text cell.
Note: You can optionally click the down arrow on the Insert button to specify the addition of a chart, grid, or text.
Now, three visual cells display side-by-side.
Note: You can click a visual to activate it, or double-click on the visual number or name in the Query pane.
Note: The Change icon updates depending on the chart, map, or grid that you select from the Select a Visual menu. By default, the Change icon displays a stacked bar chart.
You can change the type of visual that you previously selected at any time. You can also resize or reorganize the position of each visual as you add data.
For example, move the lower-left visual to the top of the visualization.
The bubble chart now runs across the top of the visualization.
When working on a visualization with more than one chart, map, or grid, you can maximize and minimize individual visuals. This allows you to focus on one visual at a time, and then minimize it to view it alongside the other visuals.
The maximize and minimize icons are located in the top-right corner of each visual, next to the Close button. When you click the Maximize icon, the current visual moves to the foreground and is the only visual that displays on the canvas. You can work on this visual, and then minimize it to view the other visuals.
Note: You can view other visuals in the maximized mode by selecting a different visual in the Query pane.
You can maximize one visual at a time, and you can switch between visuals in this mode by double-clicking a different visual in the Query pane.
Note: You can use the Undo and Redo options on the Quick Access Toolbar to reverse or redo any prior actions.
You can rename a visual on the canvas or within your visualization. You may want to do this for presentation and organizational purposes, as each visual has a default label (for example, Bar 1, Bar 2, and Bar 3). You can change these labels by renaming the visual in the Query pane.
Once new labels are in place, it is easier to recognize which visual you want to select at any given time.
Using the shortcut menu for a visual in the Query pane, you can also rename your visual.
WebFOCUS |
Feedback |