Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents
maxLevel2
minLevel2
indent15px

Switch to chart view

To switch from the standard grid to see your data as a chart select the chart icon. You can switch between grid and chart using these icons. The active icon is always green. 

Image Removed

Overview of chart types 

The chart types available are listed below. Select the chart name to go to an article on a particular chart type.

Note that some charts are only available with certain sets of data.

Chart type and link to more informationHow chart appearsWhen this chart type is available

Bar

Image Removed

   Image Removed

Summary view

All modes apart from transaction.

With a dimension selected

All modes apart from transaction and search.

Bullet

Image Removed

Image Removed

Summary view

Stream and period modes.

With a dimension selected

Stream and variance modes. 

Column

Image Removed

 

 Image Removed

Summary view

All modes apart from transaction.

With a dimension selected

All modes apart from transaction and search.

Line

Image Removed

 

 Image Removed

Summary view

All modes apart from transaction and total.

With a dimension selected

All modes apart from search, variance, stream, total and transaction.

Pie

Image Removed

 

 

Image Removed

Summary view

All modes apart from period, moving, stream and transaction.

With a dimension selected

All modes apart from search, variance, stream and transaction.

Area

Image Removed

 

 Image Removed

Summary view

All modes apart from transaction and total.

With a dimension selected

All modes apart from search, variance, stream, total and transaction.

Bubble

Image Removed

 

 Image Removed

Summary view

All modes apart from transaction mode.

With a dimension selected

All modes apart from moving mode and transaction.

Combo

Image Removed

 

 Image Removed

Summary view

All modes apart from transaction and total.

With a dimension selected

All modes apart from period, moving mode and transaction.

Gauge

Image Removed

 Image Removed

Summary view

Not available.

With a dimension selected

All modes apart from transaction.

Summary

Image Removed

 

 Image Removed

Summary view

Not available.

With a dimension selected

All modes apart from transaction.

Map chart

Image Removed

Image Removed

 

 

Select a chart type 

Charts are grouped into clusters. Select a chart type to reveal similar options. E.g., Select the Bar icon to reveal bar, column and combo chart types, as shown below.

Image Removed

Select and focus on a chart segment

Insert excerpt_Select and focus on a chart segment_Select and focus on a chart segmentnopaneltrue

Export a chart as an image

If you want to print a chart or add it to a document or email, the simplest method is to download it as an image via Export > image, as shown below. You can then save the image and use as required.

Image Removed

Export from the dashboard

To export a chart directly from the dashboard, select the camera icon on the widget toolbar.

Image Removed

Amount of data displayed in a chart

By default, only the first 25 rows are included in a chart. Your administrator can change this setting. Chart options on this page summarizes ways of customizing a chart, e.g., displaying a sum instead of individual values. 

Charts are only available if you are connected to the internet.

 

Info
iconfalse
titleRelated articles
  • Chart options 
  • Chart legends

    Charts are a great way to visualize the data and see trends at a glance. Charts are particularly useful when the grid has a lot of data - rather than scrolling through multiple columns or rows, you can get a visual overview of the data instead. You can switch between different types of charts and configure how the data displays in each one. You can save the chart as a favorite or add it to a dashboard for quick access to the data insights.

    Switch to chart view

    You can switch from the default grid view to the chart view any stage during your analysis. The same information is presented in chart view; it is just in a different format. Click the Chart button in the top right toolbar above the grid. A default chart displays, with chart category buttons on the left.

    Image Added
    Info

    By default, only the first 50 rows of a grid are included in the chart. If you have a requirement for additional rows to be displayed, your Phocas consultant can assist with this.  You can also display a sum instead of individual values (see Chart options).

    Select a different type of the chart

    In chart view, click a category button to view the chart type options, then click the chart you want to view.

    The type of charts that are available during your analysis depend on:

    • The type of data you are viewing.

    • Whether you are in Summary view or a focused view (after selecting a dimension). During your analysis, you might want to return to the Summary view to get a more concise view of the data. Some charts, such as line chart, display best when they have less details.

    • The mode you have selected.

    • Other factors, such as the measures or properties you have selected.

    The following table lists all the charts. As outlined above, some charts are only available in certain situations. Click the chart links for more detailed information and examples.

    Type of chart

    Description

    Example

    Bar

    Displays several variables together, in horizontal bars.

    Useful for displaying simple comparisons, such as revenue each month.

    Image Added

    Column

    Same as the Bar chart but displays the variables in vertical bars (columns) instead.

    Image Added

    Combo

    Displays a combination of a Column chart and Line chart.

    Useful for making comparisons, such as sales vs budget.

    Image Added

    Pareto

    Shows the relative importance of differences between large sets of values.

    Useful for root cause analysis.

    Image Added

    Waterfall

    Displays an overview of positive and negative changes to a value over time.

    Useful for getting a clear picture of growth or decline in performance, such as that if your Sales Reps.

    Image Added

    Line

    Plots performance over time.

    Useful for making comparisons, such as sales this year vs. last year.

    Image Added

    Area

    Plots performance over time, displaying data as a shaded ‘area’ that falls below a set of points connected by straight lines.

    Useful for visualizing comparisons, such as product profit over time.

    Image Added

    % Area

    Same as the Area chart but the shaded areas are based on percentages rather than amounts.

    Provides a different way to view proportional areas and has tooltips that display data details. 

    Image Added

    Pie

    Displays the percentage share of a number of variables in a pie shape, where each segment is proportionate to the percentage value.

    Useful for visualizing comparisons, such as revenue by region. 

    Image Added

    Donut

    Same as the Pie chart but displays the data in the shape of a donut rather than a pie.

    Image Added

    Gauge

    Displays performance against a range.

    Useful for tracking performance against a target, such as Sales Rep performance, as illustrated in the dashboard image below.

    Image Added

    Bullet

    Displays results in a single column.

    Looks similar to a Column chart but has more in common with a Gauge chart.

    Useful for tracking performance against a target.

    Image Added

    Summary

    Displays just one number, either alone or with an icon, on a card.

    Useful for displaying large numerical values, such as your total sales for the month.

    Image Added

    Ring Summary

    Same as the Summary chart but displays the value and other elements within a ring.

    Image Added

    Bubble

    Displays color-coded circles (bubbles) plotted on an X and Y-axis to represent measures. 

    Useful for comparing measures, such as cost v revenue.

    Image Added

    Radar

    Plots variables by providing an axis for each variable, arranged radially (like bicycle spokes) around a central point. 

    Useful for charting matrix results, in other words, such as sales by product class and customer type.

    Image Added

    Map

    Displays a map with data points identified by a marker, circle or colored heat map.

    Useful for locating data points of interest on a map.

    Image Added