51黑料不打烊

Select Create.

{modal="regular"}

Set the Data block location.

The data block location option defines the worksheet location where Report Builder adds the data to your worksheet.

To specify the data block location, select a single cell in the worksheet or enter a cell address, such as a3, \\\$a3, a\\\$3 or sheet1!a2. The cell specified becomes the upper-left corner of the data block when the data is retrieved.

Use to pick a data block location from the current selected cell in the sheet.

Choose the Data views.

The Data views option allows you to choose a data view from a drop-down menu or to reference a data view from a cell location.

Select to create a data view from a cell.

Set the Date range.

The Date range option allows you to choose a date range. Date ranges may be fixed or rolling.

Select Calendar to pick a data range using or enter a date range manually. Optionally, you can pick a preset from the Search Presets drop-down menu.

Select From cell to define a start and end data based on a cell in the current sheet.

For information about date range options, see Select a date range.

Select Next.

After you configure the data block, you can select dimensions, metrics, and segments to build your data block. The Dimensions, Metrics, and Segments tabs are displayed above the Table pane.

Add Dimensions, Metrics, and Segments components.

Scroll the component lists or use the Search components field to locate components. Drag and drop components to the Table pane or Double select a component name in the list to add the component to the Table pane.

Double select a component to add the component to a default section of the table.

• Dimension components are added to the Row section or to the Column section if you have a dimension already in the columns.
• Date components are added to the Column section.
• Segment components are added to the Segments section.
• Metrics components are added to the Values section.

Arrange the items in the Table pane to customize the layout of your data block.

Drag and drop components within each list in the Table pane to reorder components or select and select Move up, Move down, and more to move components within a list.

When you add components to the table, a preview of the data block is displayed at the Data block location in the worksheet. The layout of the data block preview automatically updates as you add, move, or remove items in the table.

Optionally set the Start date as a dimension to identify the start date of your data block. Adding the start data as a dimension is helpful if you have a regularly scheduled report that has a rolling date range. Or if you have an unconventional date range and you need to be explicit about the start date.

Optionally, display or hide row and column headers. To do so:

1. Select the Table settings icon.

   

2. Check or uncheck the option to Display row and column headers. The headers are displayed by default.

Optionally, you can also hide or show dimension labels and metric headers. To do so:

1. Select on the dimension label or the column header to display the context menu.

   

2. Select Hide or Show to toggle the dimension label or column header. All labels are displayed by default.

Select Finish to finish the configuration of your data block.

A processing message #BUSY is displayed while the analytics data is retrieved.

Report Builder retrieves the data and displays the completed data block in the worksheet.