Creating Data Grids

Data grids can be used to present data in tabular form. For example, you can create a grid (table) that summarizes your data.

Note: Data grids require at least one measure and one dimension. Additional measures create unique columns. You can add multiple dimensions in the Row bucket to create customized rows based on the structure of your selection.

The following display options are available for a data grid:

• Change chart orientation. Switches the sort fields in the Row and Column buckets.
• Clear buckets content. Empties all buckets.

You can add fields to the following buckets for a data grid:

• Measure. Supplies the measure values to display in the cells of the data grid.
• Row. Use a dimension field to define the rows in the data grid, similar to the BY field in a report.
• Column. Use a dimension to provide an additional sort column for each value. Each measure column is nested within each column field value. The column bucket is similar to an ACROSS field in a report.
• MultiPage. Enables the creation of multiple graphs based on the field that you place in this bucket.

Procedure: How to Create a Data Grid

1. From the WebFOCUS Home Page, click the Designer tab, and then click Chart.
2. Choose a data source and click Select.
3. Add one or more measures and dimensions to the chart.

   The data grid refreshes with your selections, as shown in the following image.

   

4. You can perform the following tasks with your data grid:
   1. Add additional measures or dimensions to the chart, where applicable.
   2. Change the fields to obtain different information.
   3. Format the chart (for example, customize the header and footer or style the legend).
5. Save your data grid.