Grouping and Summarizing with the Chart Expert

Objectives

After completing this lesson, you will be able to:

  • Visualize report data using advanced layout

Charting using Advanced Layout

The Advanced layout allows you to create a chart based on specific values. Since charts are a good way to display summarized information, they are often based on a summary field in your report. With an Advanced layout, you can create a chart without the need for a summary field by using values that appear in the Details section of your report.

To create a chart based on the Advanced layout, you must specify two things:

  • Conditions: You can use two conditions.

  • Values: You can use multiple values.

Condition

The condition is used to indicate when to plot the point. For example, a chart showing last year's sales for your customers uses the Customer Name field as the condition. Each time the condition changes (in this example, the customer name changes), a point is plotted.

You also have the option of plotting a point for each record, or plotting one point for all records.

Value

The Advanced chart uses the value to indicate what information is plotted as the points on your chart. For example, to create a chart showing last year's sales for your customers, the Last Year's Sales field would be the value.

Create a Chart using Advanced Layout

Log in to track your progress & complete quizzes