Exago Logo
Search
Generic filters
Exact matches only

ExpressView: Visualizations (v2021.1+)

Visualizations, also known as charts or graphs allow data to be showcased in a visual format. They allow data to be scanned quickly for patterns and trends. Charts can be easily made and customized in ExpressViews, in as little as one click.

85aBFZxgwS.png
A 3D Pie Chart visualization with pastel custom coloring showing the percentage of sales made by each salesperson, with a tooltip showing the exact percentage for Margaret Peacock

Note

This section applies to ExpressView in v2021.1+ of the application. For previous versions, refer to ExpressView (pre-v2021.1)

Table of Contents

Use the links below to skip to the applicable section of this article.

  1. Adding a Visualization

    1. Type
    2. Data

      1. Labels
      2. Values
    3. Appearance

      1. Chart Titles
      2. Chart Colors
      3. Chart Data
  2. Interactive Editing

    1. Drilling Down
    2. Editing a Chart Directly
  3. Suggested Reading

Adding a Visualization

To add a chart to an ExpressView:

  1. Click the Add Visualization ShowViz.png icon in the toolbar. A bar chart is added and populated with the data from the ExpressView automatically.
  2. On the VizMenu.pngVisualizations tab of the Properties Pane, select the type of chart you want to use. The chart immediately swaps to that type. Choose from Bar and Column, Pie and Other Single-Series, Line and Area or Miscellaneous. Review the Type section below for more information about each type.

There are three small icons in the lower-right corner of the visualization that determine where on the canvas the chart will appear. Choose from:

  • VizTop.png / VizTopSelected.png — the chart will appear on the top of the canvas; report data will be on the bottom
  • VizBottom.png / VizBottomSelected.png — the chart will appear on the bottom of the canvas; report data will be on the top
  • VizFull.png / VizFullSelected.png — the chart will fill the canvas; report data will be hidden

Use the VizMenu.pngVisualizations tab of the Properties Pane to customize the visualization:

Type

Choose one of the available chart types to display. Charts are organized into four general categories. Click each type name for additional information.

Data

Labels

The Labels field is a group of data values, for each iteration of the group represented as a series on the chart. For example, using the Product Category group field as the label field represents each category as a series.

SZwqbvTALc.png
A Bar chart with one label field on the product category, showing the number of products in each category

Several chart types allow more than one label field. This is useful for nested groups, which represent common series measured across several groups. For example, to compare the number of products in each category manufactured by a particular manufacturer, a nested manufacturer field can be added as a second label.

CJkGCM29MW.png
A Bar chart with two label fields: one on the product category, and the other on the manufacturer’s code number showing the number of products in each category made by each manufacturer

To add a chart label, either:

  • Drag a data field from the Data Objects Pane onto the chart and release on the Add Label drop zone.
    pMM462tVb6.png
    Adding LastName as a label by dragging it to the drop zone on the chart
  • In the VizMenu.png Visualizations tab, click the Data tab. Either:
    • Drag a data field to the Labels drop zone.
    • Click AddBtn.png Add Label, then select a field from the Field list.
FunDSPjRQo.png
Adding LastName as a label by dragging it to the drop zone in the Properties Pane

Values

The Values fields are the data values to plot on the chart for each iteration of each labels group. For example, the products per category.

Several chart types allow for multiple values fields. This is useful if there are common series to be measured across several groupings, and the values fields are in the same data row. For example, the number of products per category and the number of views of those products on the online shopping site.

NgIpzPNWlE.png
A Stack Bar chart with two values fields: one on the distinct count of model numbers and the  sum of views in the online shopping cart system for each category

To add a chart value, either:

  • Drag a data field onto the chart and release on the Add Value drop zone.
    kf3HGoEeyx.png
    Adding OrderId as a value by dragging it to the drop zone on the chart
  • In the VizMenu.png Visualizations tab, click the Data tab. Either:
    • Drag a data field to the Values area.
    • Click AddBtn.png Add Value, then select a field from the Field list.
Fkz7n86TF4.png
Adding OrderId as a value by dragging it to the drop zone on the Properties Pane

Appearance

Set the styling for the Chart Titles, Chart Colors and Chart Data:

Chart Titles

3XxptcVH0W.png

Add a main title and subtitle, as well as X-Axis and Y-Axis labels in this section. Each title may have a unique font, color and size.

Chart Colors

wmZd82SEoa.png

Select a palette to color the chart elements with. Choose from:

  • Theme — a variety of named color themes are available (e.g. Blue Gray, Emerald Forest, Prismatic Wave, etc…)
  • Linear Range — choose a starting and ending color. The application will interpolate intermediate colors for 3 or more chart elements as needed.
  • Custom — the color of each element may be explicitly specified by manually choosing colors

Check the Use 3D Style checkbox to enable a three-dimensional effect on the chart elements.

cYwCnlWLNb.png
rWOVTVgobO.png
A multi-value Column chart with Use 3D Style unchecked (top) and checked (bottom)

Chart Data

Use the Data Axis Min Value and Data Axis Max Value fields to set the minimum and maximum values for the axes. All values in the chart must be above the Data Axis Min Value and less than Data Axis Max Value otherwise this setting will be ignored. These settings can help make a chart easier to read. For example:

64oF71vAXv.png
q9wqqu8jOo.png
The same line chart without (top) and with (bottom) min and max values set

Use the Exclude Values Less Than and Exclude Values Greater Than settings to exclude values outside of the set range from appearing on the chart.

Use the Sort By dropdown to apply a secondary sort to the chart that will affect the order Values are added to the visualization. Choose from Ascending or Descending order by selecting from the dropdown. The options available will differ by chart type, but in general they are:

  • Report Order — data points are added to the chart in the order they appear on the report
  • Data Labels — data points are sorted by their Labels
  • Data Values — data points are sorted by the Values

Point Labels will display the exact values of each point on the chart. Different chart types will have different options available, but in general they are:

  • Series Values or Point Value — display the value of the values or point
  • Percent of Series Values or Percent of Point Value — displays the percentage of the whole represented by this value or point
  • Data Labels or Point Label — display the names of the Labels represented by each segment of the chart
  • Data Labels with Data Values or Point Label with Point Values — combine the behavior of both Data Labels and Series Values modes to place both pieces of information in the label

For some charts, the Point Labels may be positioned with the Label Position setting. Choose from:

  • Auto: allow the application to select the best orientation for you based on available space
  • g68qOn5XeZ.pngSlant: rotate the labels 45-degrees along the axis
  • sKYCRS3Dta.pngWrap: texts wraps to a new line
  • niDP7gwXFf.png Stagger: values are staggered along two lines so they don’t overlap
  • 7YBRqc1t7H.png Rotate: rotate the labels 90-degrees along the axis
  • Sm9YGoPcF6.png None: do not apply any change to labels, they may overlap

To include a Legend on the chart, click either Right or Bottom. Choose None to remove the legend.

The Number Format settings determine how numbers appear on the axes and in the Point Labels (if applicable):

  • Decimal Places will force a specified number of decimal places to be displayed. The symbol inserted between the whole and fractional part of the number can also be specified.
  • Use 1000 Separator — when checked, will separate thousands places with the specified symbol
  • Use Currency Symbol — when checked, will display the specified currency symbol in front of the value (e.g. $3.14)
  • Append Percent Sign (%) — when checked, will display a percent sign (%) after the value (e.g. 3.14%)

Interactive Editing

Drilling Down

When Live Data (Run) is enabled, click on a chart series to drilldown the data to that series.

Note

Because some of the data is hidden in this mode, totals and other calculations may not be accurate.

OwtFHQFsDu.png
Clicking the Fuller series highlights only that series in the chart, and shows only those records that comprise that section of the chart

Several series may be drilled at the same time.

THUVespRlS.png
Drilling into both the Condiments and Grains/Cereals categories highlights them on the chart and shows their applicable records

Click AccordionDeleteItem.png Clear selected points to remove the drilldown and return to the original report design.

Editing a Chart Directly

Right-click on a chart to open the interactive menu.

ng7POhmtzp.png
Chart interactive menu

Choose from:

  • Type — change the chart from one type to another as in the Type section of the Properties Pane. Only charts of the same series type may be selected. That is, if the chart is a multi-series type of chart only other mutli-series charts may be selected.
  • Theme — change the color palette of the chart as in the Chart Colors section of the Properties Pane
  • Legend Location — change the location of the legend
  • Sort By — change the sort order on the chart as in the Chart Data section of the Properties Pane
  • Invert Data — swap the data fields on the X and Y axes

Suggested Reading

Additional resources may prove helpful when working with ExpressView and ExpressView Visualizations:

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents