Versions Compared

Key

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

...

Charts are a graphical representation of the report. There are several chart options that allow you to display the information in a more effective manner.

...

Ad Hoc Editor’s Chart Layout

...

Component

...

Description

...

Rows area

...

Drag fields and measures to the Rows area to define the grouping along the horizontal axis. All measures must be in the same area. You can't have measures in the Columns and Row areas at the same time. Right click a measure to change its summary function.

...

Columns area

...

Drag fields and measures into the Columns area to add series. All measures must be in the same area. You can't have measures in the Columns and Row areas at the same time. Right click a measure to change its summary function.

...

Sliders

...

Drag to set the level of aggregation to use for viewing the data.

...

Canvas Options

...

Click to select the Select Chart Type or Chart Format window.

...

Select Chart Type window

...

Select Canvas Options to display this dialog. Click to select a chart type; a blue border indicates the current selection. Click and drag to move the dialog; click Image Removed to close it.

...

Chart area

...

A chart’s appearance is determined by the type of chart, the fields selected as measures, and the fields that group the data.

...

Scale

...

All measures are plotted against the same scale, which is sometimes confusing. You can use a calculated field to multiply or divide one measure so that its values are closer to those in the other measures in your chart.

...

Legends

...

The legend is created when measures are added to the chart. Click one or more legends to hide the associated measures; click again to show them.

...

Labels

...

The labels on the horizontal scale indicate the values by which the chart is grouped. If there are too many values in the chart, zoom in or use filters to reduce your data.

...

Image Removed

...

Because the nature of a chart is to display summarized data, the data mode menu is not available. Charts always present the full data set, not a sample. This may impact performance when working with large data sets.

Common tasks when working with Ad Hoc charts include:

...

Zoom

...

Click and drag or swipe to zoom. Only labels used in the zoom area are displayed, so you can use zoom to simplify your view. The zoom level is not saved when you save a view or report.

...

Filter a chart

...

Right-click a field in the Data Selection panel or the layout band and select Create Filter.

...

Select a measure’s summary function

...

Right-click the measure’s name in the layout band and select a function from the context menu.

...

Set the granularity of groups

...

Use the slider to specify the granularity of groups.

...

Image Removed

...

Because charts and crosstabs both work with summarized data, you can sometimes change your chart display by switching to crosstab view and making the correct selection there. For example, you can often change the sort order in a chart by switching the view to crosstab, making the sort selection you want, and then switching back to chart view.

Crosstabs

Crosstabs summarize data across multiple sets of related fields.The rows and columns represent properties while the cells contain the data that connects these properties. Both rows and columns may be grouped in order to break the data down even further.  

...