Using Insight to Analyze Dynamic Charts

In this section:

How to:

Insight is a visualization tool that allows for the interactive selection of measures and dimensions, so you can create dynamic charts that refresh as you make changes.

With Insight, you can review and analyze a chart that shows the data fields that you choose in real time. It even rebuilds as you select additional fields or specify filters.

You can make quick decisions regarding your data with Insight. Using logical menus and simple filtering, you can analyze charts interactively to suit your needs. As you select additional fields and create filters, your chart refreshes instantly, letting you see the results of your data choices as you use the tool.

Insight lets you build filters, as needed, to customize the data that displays. You can add and remove fields, at any time and in any pattern, to enhance your chart. You can take advantage of the customization options that are available to you right from the toolbar.

With Insight, the chart type determines the buckets that display. For example, if you are working with a pie chart, you can specify values for the following buckets: Measure, Rows, Columns, Color, Size, Tooltip, and Animate.

Available fields are organized into applicable Dimension and Measure categories. You can use the plus sign to add additional fields to your chart. For example, if you want to create a bar chart that plots Gross Profit, Revenue, and MSRP for each Product Category, click the plus sign to add fields using the drop-down field selector. Once you choose the fields that you want to include, you can rearrange them by dragging and dropping them into the order that you prefer.

The resulting bar chart displays, as shown in the following image.


Insight bar chart

Note: The Save icon only displays when running an existing Insight chart from the WebFOCUS Hub or Home Page.

You can use the navigational arrows in the interactive header to move between the available buckets in your chart. The following image highlights these arrows, which shift the focus of these buckets to the right or left.


Toolbar with scroll arrows

All charts support a bucket for Color, which adds contrast to your chart. Some charts also support the Size bucket, which binds a measure to the size of the markers rendered on the chart.

Once you have added fields to the relevant buckets, you can use the Sort arrows adjacent to each field to sort the data in ascending or descending order. This helps identify trends and priorities within your data. You can only sort one field at a time. Ascending order sorts your data from the smallest value to the greatest value, while descending order sorts your data from the greatest value to the smallest value, as shown in the following image.


Insight chart sorted by descending MSRP

When you select a sort order for a field, the field arrow changes color, appearing bolder than the unsorted fields. In the image below, a sort order was selected for MSRP, so the field arrow appears black.


MSRP field sorted

Specify measures and dimensions for your chart in WebFOCUS Designer before using Insight. This pre-loads the Insight user interface (UI) with those selections. Optionally, you can use Insight without selecting any fields. In this case, the field selection options are broad, meaning that all fields will be presented. An example of an empty canvas is shown in the following image.


Insight toolbar with no fields

Insight can be enabled for stand-alone charts, and you can access Insight functionality when these charts are run on their own or as part of an assembled visualization. When added to an assembled visualization, Insight-enabled charts display an icon that you can click to access Insight features. If you convert an Insight-enabled chart to a page with new content, a warning appears, alerting you that Insight functionality will not be carried over.

Procedure: How to Enable Insight From WebFOCUS Designer

  1. Open WebFOCUS Designer. On the WebFOCUS Hub, click the plus menu and then click Create Visualizations, or, on the WebFOCUS Home Page, click Visualize Data.

    WebFOCUS Designer opens in a new browser tab.

  2. Select a workspace and a data source available from that workspace.

    Once you select a data source, WebFOCUS Designer loads with options to create a single content item.

  3. Optionally, change the chart type and add fields to the chart.

    Insight can be run with no fields applied, allowing you to create an entirely new chart in Insight.

    Note: Insight is not available for reports.

  4. On the Settings tab of the Properties panel, expand the Content section and select Run with Insight.
  5. On the toolbar, click Run in new window.

    The chart opens with the Insight toolbar available, and you can begin modifying and analyzing your chart.

Working With Charts in Insight

In this section:

How to:

With Insight, you can choose individual fields for the buckets that you add. Whether you added fields into the buckets before running Insight or left them empty, creating a chart in Insight is streamlined to allow you to easily create a dynamic chart in real time. It also provides you with the flexibility of interactive comparison as you change your data selections rapidly and adjust the options for display.

You can use the default vertical bar chart or you can specify a different chart type using the Chart Picker in the Options toolbar.

In addition, you can reorder the display of fields in your chart. This allows you to change the placement of a particular field, giving you control over where the data for this component displays in your chart.

Procedure: How to Configure a Basic Bar Chart Using Insight

  1. Click the plus icon under the Vertical Axis bucket.
  2. Choose a measure field from the drop-down list.
  3. Click the plus icon under the Horizontal Axis bucket.
  4. Choose a dimension field from the drop-down list.

    Your bar chart displays, as shown in the following image.


    Bar chart in Insight

Procedure: How to Change the Chart Type in Insight

  1. On the Options toolbar, click Chart Picker.

    The table of chart selections opens, as shown in the following image.



  2. Select a chart type.

    Your chart refreshes with the new chart type, and the Insight interface refreshes to display all of the buckets that are relevant to the current chart type.

Procedure: How to Delete a Field From a bucket

  1. Add one or more fields to your chart.
  2. Hover over the field that you want to delete and click X, as shown in the following image.

    X button on Revenue field

    The chart refreshes to reflect your selections.

Procedure: How to Reorder the Display of Fields in a Bucket

  1. Add multiple fields to your chart, as shown in the following image.

    Bar chart in Insight with 2 measures
  2. In the Vertical Axis grouping, drag the second bucket into the first position. The placement of the field is shown by a dark blue vertical bar, as shown in the following image.

    reordering Quantity Sold to before Discount

    The following image shows the newly ordered fields.


    bar chart with reordered fields

Searching for Fields

You can locate fields for your buckets using the search option. On the toolbar, click the plus sign. In the search field, start typing the field that you want to locate. You can type in whole words or partial words. The search identifies all fields that contain any instance of the characters that you specify, as shown in the following image.

Changing Summary Operators for the Field

When working with measure fields, you can change the summary operators for the field from Summary (default) to Average, Maximum, or Minimum. You can also change a Count field to Count Distinct, using a similar menu selection.

When you make a selection, the axis of the relevant measure updates in the chart, as shown in the following image.


bar chart with Average MSRP

Options for changing the Summary field are shown in the following image.


changing summary aggregation in Insight

Filtering in Insight

In this section:

To enable filtering, click the Show Filter icon, which is located in the Options section of the toolbar. This opens the filter shelf that renders above the bucket shelf, as shown in the following image.


Insight chart with filter toolbar

Use the filter shelf to build your filter. The filter shelf must be visible in order to add or modify a filter. In addition, constant value filters that were created in a procedure (.fex) or in InfoAssist, as well as all filters created in WebFOCUS Designer, are applied and display on the filter toolbar in Insight. Parameter filters created in InfoAssist, on the other hand, do not display in Insight. When Insight is enabled, prompted filters created in WebFOCUS Designer are always multi-select and optional, because single-select filters and required filters are not available in Insight.

Additionally, query variables are available in Insight and functional on the Filter shelf. Typically, query variables display in the Data pane, above the measure fields. The filter values display as True or False, rather than one and zero. In addition, you can only select one value, as shown in the following image.

Types of Filters

There are different types of filters in Insight. For example, if you are filtering with a date field, you can use a built-in calendar to select a date range, as shown in the following image.

If you are filtering on a numeric value, such as a measure value, you can filter on values that are specific to a field. In this scenario, when you define the filter, a slider control opens. You can adjust the range of values that you want to include, using the slider control options, as shown in the following image.

You can also filter on dimension values. You can select one or more values by simply clicking on multiple values. A check mark appears, indicating the values selected, as shown in the following image.

You can select all values for the dimension, select one or more, or clear all selected values, as shown in the following image.

Adding a Filter

How to:

You add a filter when you want to limit the display of your data, or drill down to focus on specific data values. For example, you may want to just display data for Camcorder and Televisions, rather than all Product Categories. You can do this by adding a filter for the Camcorder and Televisions, as shown in the following image.


Insight chart filtered for Product Category

Procedure: How to Add a Filter in Insight

  1. In the Options toolbar, click Show Filter.

    The filter shelf opens.

  2. Click the Show Filter icon.
  3. From the drop-down list that opens, select the field on which to filter.
  4. Click the identified field in the filter shelf to specify a value for the filter.

    A list displays, showing the values that you can select.

  5. Click on the filter shelf to save your filtered items.

    Your chart refreshes.

Removing a Filter

To remove a filter, hover over it and click on the X, as shown in the following image.


X button on filter

The chart refreshes and displays your data without any filter.

Using the Options Toolbar

The Options toolbar is located in the upper-right corner of the Insight interface. These options control your interactions with your data, including options such as pivoting and filtering. You can also change your chart type using the Chart Picker option.

Reference: Options Toolbar Icons

The following section describes the icons that display on the Options toolbar.

Reset

Returns the chart to its original state. Any filters, measures, dimensions that are added in the current Insight session are reverted. The chart type is reverted, as well.

Swap Axis

Swaps the x and y axis, placing the contents of the x-axis on the y-axis. You can click Swap Axis again to change the chart back to its original orientation.

Save
Available when running an Insight-enabled chart from the WebFOCUS Hub or WebFOCUS Home Page. Allows you to save the Insight chart as a new file.
Chart Picker

Provides options for selecting different chart types, including:

  • Horizontal Bar. Offers the capability of ranking data in descending order. This chart type can also be used when x-axis labels are too long to fit legibly side-by-side. The following buckets are available for this chart type: Vertical Axis, Horizontal Axis, and Color.
  • Vertical Bar. Shows different measures per dimension component using different identifying colors. The following buckets are available for this chart type: Vertical Axis, Horizontal Axis, and Color.
  • Vertical Stacked Bar. Stacks values per dimension component using differentiating colors. The following buckets are available for this chart type: Vertical Axis, Horizontal Axis, and Color.
  • Pie. Presents values as part of a whole using colors to separate the segments. Pie charts emphasize where your data fits in relation to the larger whole. The following buckets are available for this chart type: Rows, Columns, Measure, Color, and Size.
  • Vertical Line. Creates a line chart which is representative of the data. Line charts are useful for showing trends in numerical data. The following buckets are available for this chart type: Vertical Axis, Horizontal Axis, and Color.
  • Area. Creates an area chart which is similar to a line chart except the area between the data line and the zero line (or axis) is usually filled with color. The following buckets are available for this chart type: Vertical Axis, Horizontal Axis, and Color.
  • Scatter. Plots data using variable scales on both axes. The following buckets are available for this chart type: Rows, Columns, Vertical Axis, Horizontal Axis, Size, Detail, and Color.

    Note: When working with Insight Scatter or Bubble Charts, the "Show Datalabels" ability is tied to the Size bucket. Therefore, you will only see datalabels if there is a measure in the Size bucket.

  • Circle. Plots differing values in rows, enabling you to draw inferences as to how the values overlap. The following buckets are available for this chart type: Rows, Columns, Vertical Axis, Horizontal Axis, Size, Detail, and Color.
  • Treemap. Displays large amounts of hierarchically structured data. This chart type uses sections to represent an aspect of the selected measure. The following buckets are available for this chart type: Grouping, Size, and Color.
  • Histogram. Analyzes the distribution of a measure while assigning it to buckets based on the values you specify for the bins that are created. The default bin count is 10. The following buckets are available for this chart type: Rows, Columns, and Measure.
  • Table. Presents data in tabular form, allowing you to compare various intersections in your data. The following buckets are available for this chart type: Rows, Columns, and Measure.
  • Matrix. Analyzes one or two measures against a crosstab of two categorical dimensions. The following buckets are available for this chart type: Rows, Columns, Size, and Color.
  • Point Map. Uses symbols of different sizes to represent data associated with different areas or locations within the map. The following buckets are available for this chart type: Layer, Size, and Color.
  • Choropleth Map. Visualizes location-based data, trends, and distributions across a geographic area. These maps are geographically-based heat maps. The following buckets are available for this chart type: Layer and Color.

Note: The orientation of this chart icon changes if you swap an axis. In addition, the image that displays for the chart type changes, based on your selection.

Show Filter

Defines filters for your data. Select this icon, and using the filter shelf that opens above the bucket shelf, click the Show Filter icon to define a filter.

Note: To select one or more non-consecutive values, select each field. The selected values will display with a check mark to indicate that they have been selected.

More Options

Opens the following additional options:

  • Export Data. Exports the underlying data of the current chart to an Excel file in LOCAL file storage. You will be alerted when the file appears in the bottom left corner, similar to any other file that you download.
  • Export Image. Generates an image of the current chart, which is saved in PNG format to LOCAL file storage using the current width and height of the browser window.
  • Series Layout. The bar, line, and area charts in Insight support several different sub-graph types (aka Layout). The supported graph types include: horizontal bar, vertical bar, vertical stacked bar, line, and area charts. For bar, line, and area charts, the Series Layout Options are as follows:
    • Horizontal Bar: Stacked, Side-by-Side, Absolute, Percent
    • Vertical Bar: Stacked, Side-by-Side, Absolute, Percent
    • Vertical Stacked Bar: Stacked, Side-by-Side, Absolute, Percent
    • Line: Stacked, Side-by-Side, Absolute, Percent
    • Vertical Stacked Area: Stacked, Side-by-Side, Absolute, Percent
  • Y-Axis Log Scale. Adjusts the log scale on the y-axis. This option is always unchecked, by default. The following chart types are supported:
    • Horizontal Bar
    • Vertical Bar
    • Vertical Stacked Bar
    • Line
    • Area charts
    • Scatter charts
    • Circle
    • Histogram
  • X-Axis Log Scale. Adjusts the log scale on the x-axis. This option is always not selected, by default. The following chart types are supported:
    • Scatter
    • Bubble
  • Change Bin Size. Changes the size of the bin (numeric value only). This option is only available for histograms. Clearing the text box switches it back to automatic bin size generation.
  • Show Data Label. Turns numeric Data labels on/off on all charts, except Grids. The default for this setting is always Off except for Treemaps.
  • Show Totals. Turns the Summary Row Total on Data Grid on or off. The default for this setting is always False.
  • Marker Shape. Changes the marker shape used in the matrix marker chart. Options include: Circle, Square, or Fill.

Using Insight in Phone Mode

In this section:

Phone mode, which is available in Insight, allows you to take advantage of the features of Insight on your phone. The interactive heading that is available in Insight on a tablet or desktop is replaced by a static heading that displays the field names in the chart, in blue text. These become summary fields that allow you to see what fields are included in the chart.

Insight is mobile aware and mobile-friendly. Full functionality is available on tablet devices and other high-resolution touch displays. On smaller devices, such as an iPhone, Insight enters a special phone mode which has a useful, but more limited, set of options and features that are tuned for the small screen real-estate of the device. In this mode, you can add or modify filters to narrow your data as needed. You can also hover over data points to see the underlying data.

Measures are shown first. The first measure displays with a summation attribute (for example, Sum or Avg) and then displays of and then the name of the measure, as shown in the following image.

In the above image, area one is the static heading. Area two marks the filtering side option button. Lastly, area three shows the conbody of the chart.

Numeric measures are displayed after the measures in the order of Y-Axis and then X-axis. If you define fields in your Grouping bucket, they display after the collective measures and are preceded by the word by. If you have created a matrix marker chart, the relevant buckets for these display next. They also use the word by, as do any Detail buckets that are populated in the chart. If your chart specifies a field for color, Phone mode precedes the display of this item with color by. Lastly, if you have populated the Size bucket, this displays last and is introduced by size by.

User Options in Phone Mode

In this section:

You have a number of options in Phone mode, including robust filtering and hover capabilities.

Filtering

In Phone mode, you can filter just like in regular desktop mode. The primary difference is that the filter shelf stacks the available filters in a vertical row, as shown in the following image.

You click the filter icon to bring up the filter shelf and then you click the X to close it. If you have defined filters, closing the filter shelf merely collapses it. The filters that you defined remain intact. To remove a filter, hover over it and click the X in the upper-right corner.

General Usability

Phone mode allows you to view your chart and filter it to refine it based on your own unique scenario.

You can hover over a data bar a segment of a chart to obtain additional, detailed information from the underlying data. The tooltips that display are based on your data selections.

You can also show and hide the legend using the right arrow above the legend. When you collapse the legend, you can see more of your chart.

The opportunities for dynamic charting are vast with Insight. Using dynamic menus, filtering options, and search features, you can quickly and effectively create charts that communicate your data.