Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
You can view your data in a chart or graph to
  • Select and focus on a chart segment

  • 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 columns and you are only interested in one row or a few rows data - rather than scrolling across through multiple columns or rows, you can visualize the row(s) 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 next timeto the data insights.

    Switch to chart view

    You can switch from the default grid view to the chart view any any stage in during your analysis. Click The same information is presented in chart view; it is just in a different format. Click the Chart(blue star) button in the top right corner above the grid. You can then select a different type of chart and configure the chart to meet your needs. 

    Select a chart type 

    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 :

    • The type of data you are viewing

    and the mode
    • .

    • 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 below lists all the chart types. Click the links to view charts. As outlined above, some charts are only available in certain situations. Click the chart links for more detailed information and examples.

    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.

    Expand

    Chart

    Availability

    Category

    Type

    In Summary view

    When a dimension is selected

    Bar

    Bar

    All modes except for Transaction.

    All modes apart except for Transaction and Search.

    Column

    All modes except for Transaction.

    All modes except for Transaction and Search.

    Combo

    All modes apart from transaction and total.

    All modes apart from period, moving mode and transaction.

    Pareto

    Waterfall

    Line

    Line

    All modes except for Transaction. and Total.

    All modes except for Search, Variance, Stream, Total and Transaction.

    Area

    All modes apart from transaction and total.

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

    % Area

    Pie

    Pie

    All modes except for Period, Moving, Stream and Transaction.

    All modes except for Search, Variance, Stream and Transaction.

    Donut

    Gauge

    Gauge

    Not available.

    All modes except for Transaction.

    Bullet

    Stream and Period modes.

    Stream and Variance modes. 

    Summary

    Not available.

    All modes except for Transaction.

    Ring Summary

    Bubble

    Bubble

    All modes apart from transaction mode.

    All modes apart from moving mode and transaction.

    Radar

    Radar

    Marker

    Marker

    Circle

    Heat

    Map

    Info

    By default, only the first 25 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).

    On this page

    Table of Contents
    maxLevel2
    minLevel2
    indent15px

    Related pages

    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