Versions Compared

Key

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

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. Click the Chart (blue star) button in the top right corner above the grid. A default chart displays, with chart category buttons on the left.

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 (selected a dimension).

  • The mode you have selected.

  • Other factors, such as the measures or properties 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.

Column

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

Combo

Displays a combination of a Column chart and Line chart.

Useful for making comparisons, such as sales vs budget.

Image RemovedImage Added

Pareto

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

Useful for root cause analysis.

Image RemovedImage 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 RemovedImage Added

Line

Plots performance over time.

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

Image RemovedImage 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 RemovedImage 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. 

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 RemovedImage Added

Donut

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

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 RemovedImage 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.

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.

Ring Summary

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

Image RemovedImage 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.

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.

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.

/succ