Tài liệu Oracle CRM On Demand Dashboards- P8 ppt

Oracle-Regular / Oracle CRM On Demand Dashboards / Michael D. Lairson / 174 534-3

116 Oracle CRM On Demand Dashboards

Oracle-Regular / Oracle CRM On Demand Dashboards / Michael D. Lairson / 174 534-3

Chapter 6: Displaying Reports on the Dashboard 117

these check boxes. Some charts also allow you to identify if and where to apply

measure labels. The specific requirements of each chart type are described in the

following section.

To the right of these check box controls, you have a preview of your chart. This

preview may update automatically as you make changes, but you will find that you

need to click the Redraw button at times to refresh the preview. If you ever feel like

you have gone too far with your chart formatting, you can click the Restore Default

button to return to the default format for the current chart.

Review of Chart Types

Selecting the most appropriate charts for your dashboard will make your dashboard

more effective and accepted by your users. The point of a dashboard, after all, is to

make the delivery of a large amount of information as simple as possible. Nothing

accomplishes this better than a well-placed chart.

Area An area chart displays quantitative data by filling in an area under a series

line. Area charts are good for showing the total of two or more quantities over a

series of time—for instance, while representing the individual quantities that make

up that total.

The area chart requires you to identify columns for the bottom and left axes. In

order to populate your area chart, you need to identify the column by which to

segment the data in the chart. The values from this column appear along the bottom

axis. Identify this column by selecting the column’s check box beneath the bottom

axis icon. This is usually a nonmetric column.

Next you will identify one or more metric columns to include on the left

(measure) axis. Select the Measure Labels check box under the legend icon, and you

see a nice area chart with different color areas for each metric, with a legend that

identifies the metric associated with each color.

Horizontal Bar A horizontal bar chart displays quantitative data represented by

horizontal bars extending from the left axis. The chart displays data series as sets of

horizontal bars grouped by category. Metric values are represented by the length of

the bars as measured by the bottom axis. Category labels appear on the left axis. You

will normally use a bar chart when you want to compare values between categories.

There are two types of horizontal bar charts. The standard horizontal bar chart

represents each metric as an individual bar. The stacked bar chart displays all metric

series stacked into a single column for each category.

The horizontal bar chart requires you to identify columns for the bottom and left

axis. You must identify the column by which to segment the data in the chart. The

values from this column appear along the left axis. Identify this column by selecting

the column’s check box beneath the left axis icon. This is usually a nonmetric

column.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

Oracle-Regular / Oracle CRM On Demand Dashboards / Michael D. Lairson / 174 534-3

118 Oracle CRM On Demand Dashboards

Oracle-Regular / Oracle CRM On Demand Dashboards / Michael D. Lairson / 174 534-3

Chapter 6: Displaying Reports on the Dashboard 119

Next, you will identify one or more metric columns to include on the bottom

axis. Select the Measure Labels check box under the legend icon if you want the

legend to identify what the different color bars represent.

You must identify at least one column for the measure axis, and you cannot set

your measure labels to the measure axis. If you fail to designate a column for the left

axis, the report will use a combination of all unused columns on the left axis.

Bubble A bubble chart displays data series as a set of circles (bubbles). Metric

values are represented by the position of the point in the chart corresponding to the

left and bottom axes, and a third measurement affects the size of the bubbles.

Categories are represented by different-colored bubbles in the chart. There is only

one type and style of bubble chart.

In order to display meaningful data in a bubble chart, you will need to identify a

category, represented by the diagonal axis, or chart area. The location of the bubble

for each value is based on its relationship to the metric values on the bottom and left

axes. The fourth element is size. A metric value assigned to this element in the

bubble chart determines the size of each point in the chart. Adding a column to the

legend causes the bubble chart to show different color-coded series of bubbles.

Vertical Bar The vertical bar chart is the default chart type. Every time you add a

chart view to your report, you will always start with a vertical bar chart. A vertical

bar chart displays quantitative data represented by vertical bars extending from the

bottom axis. The chart displays data series as sets of bars grouped by category.

Metric values are represented by the height of the bars as measured by the left axis.

Category labels appear on the bottom axis. You will normally use a bar chart when

you want to compare values between categories.

As with its horizontal counterpart, there are two types of vertical bar charts. The

standard vertical bar chart represents each metric as an individual bar. The stacked

bar chart displays all metric series stacked into a single column for each category.

The vertical bar chart requires you to identify columns for the bottom and left

axes. You must identify the column by which to segment the data in the chart. The

values from this column appear along the bottom axis. Identify this column by

selecting the column’s check box beneath the bottom axis icon. This is usually, but

not necessarily, a nonmetric column.

Next you will identify one or more metric columns to include on the left

(measure) axis. Select the Measure Labels check box under the legend icon if you

want the legend to identify what the different-colored bars represent.

You must identify at least one column for the measure axis, and you cannot set

your measure labels to the measure axis. If you fail to designate a column for the left

axis, the report will use a combination of all unused columns on the bottom axis.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.