Chart

Chart-with-details2.gif

Using the Chart View you may easy visualize sales volume comparison. Furthermore, if you need to drilldown and review the details summarized in the Chart, just click on the displayed figures and the details view will be opened.

Details.gif

To create a chart view, select the Chart option from the list of view types and click Next. The system will display the Chart View form comprising the following sections:

Chart View General.png

Name Enter a name of a new chart view.
Notes TheNotes field can hold any developer’s comments that need to be kept for this view. The comments will be visible in the Setup mode only.
Show In Menu Leave this option checked if the view should be displayed in the menu.
Category Enter a category name if you want to group view under a category.
Highlight Color Select a color to highlight this view in the list displayed in the menu.
Icon This option allows to select an icon for a view. You have a choice of 900+ icons covering various subjects – actions, brands, file types, symbols, animals and a lot more. The Search box above will help you to narrow down the list of choices.
Access If you want to restrict access to the view for your users basing on their roles, select the Restrict access right by role checkbox and choose what roles will have access to this particular view.

Chart-marching.jpg

Filter The Matching section is intended to set the filter criteria for the records that will be displayed in the view.

Chart-Adjustment.gif

The Chart section allows you to select the necessary chart type and specify its parameters.

Chart Type From the Chart Type list select the necessary chart type and the example of the selected type will be displayed below.
Calculate (1) In the Calculate field specify a formula that will be used to calculate values of Y (X) axis.
Grouping (2) In the Grouping section specify the type of data that will be used to build the chart and displayed on the opposite X (Y) axis, also specify the order and the way in which the data will be grouped.
Wedges to display Use the Wedges to display field only if the Pie or Doughnut chart type is selected. Here you can specify the number of pies to display (all other entries will be grouped under the “Other” section).

Chart Advanced.png

The Advanced options section is intended to specify additional options:

Details View When the chart is built, the records are grouped and results of such grouping are shown on the chart. The Details View option provides a possibility to overview the records included in every group. As a result, on the chart each grouping value is displayed as a link. When a user clicks on such link, the details of the group are displayed. You can define what view will be used to show details of the groups. In the Details View dropdown you can select any view built in the same table.
Chart Width Specify Chart Width (Narrow, Normal, Wide).
Chart Height Specify Chart Height (Short, Normal, Tall).
Colorization Check the Colorization checkbox to color the chart according to your need. The details are expounded in the View Colorization item.
Enable Embedding This option allows you to copy/paste simple HTML snippet to embed a view on your website page. More details are described here Embedding Option for Views.

Map Help.png

Help When the Help text property is filled in, a view page displays small dropdown titled Help just under the tab bar. On user’s click it extends toward the bottom displaying the text you’ve typed.

Chart Types

You can create the following Chart Types:

Horizontal Bar Horizontal Bar - Grouped
chart_bar1.gif chart_bargrp2.gif
Horizontal Bar - Stacked Horizontal Bar – Stacked to 100%
chart_barstk3.gif chart_barstk100_4.gif
Vertical Column Vertical Column – Grouped
chart_col5.gif chart_colgrp6.gif
Vertical Column – Stacked Vertical Column – Stacked to 100%
chart_colstk7.gif chart_colstk100_8.gif
Line Line – Grouped
chart_line9.gif chart_linegrp_10.gif
Line - Cumulative Line – Grouped Cumulative
chart_linecum_11.gif chart_linecumgrp_12.gif
Area Area – Stacked
chart_area_13.gif chart_areagrp_15.gif
Area - Cumulative Area – Stacked Cumulative
chart_areacum_16.gif chart_areacumgrp_16.gif
Pie Doughnut
chart_pie_17.gif chart_doughnut_18.gif