Slicers versus columns and rows
This article describes the purpose of the slicers, columns, rows, and measures fields of the Data Analysis Panel.
The Data Analysis Panel appears when you create a new metric set or drag data items onto the dashboard canvas. You can also open this panel from the context menu for a data visualization component.
2. Data Analysis Panel
The Data Analysis Panel lets you build an analytical/OLAP view of your data simply by dragging data items from the EXPLORE window onto its various fields (or axes).
|Field / Axis||Function||Is Rendered?|
|MEASURES||Display numeric/fact values||Yes|
|ROWS||Display categories/data points||Yes|
The figure below shows the Data Analysis Panel for a table visualization on a dashboard.
One or more measures can be added to the MEASURES field of the Data Analysis Panel to display the numeric values you are interested in viewing (such as sales or stock levels). Measure values will be grouped by the row and column hierarchies that have been added, and filtered by slicers, if any.
In a table visualization, each measure appears once per grouping (e.g. COLUMNS hierarchy member Accessories is a grouping).
On a bar chart visualization, additional measures are rendered as different colored bars by default.
One or more hierarchies can be added to the ROWS field of the Data Analysis Panel to show more detailed data results (such as sales broken down by country instead of just total sales). You use this field when you want to see a row of data for each hierarchy member value or unique combination of values.
ROWS hierarchy members appear as the row headers of a table visualization.
On a bar chart visualization, ROWS hierarchy members are displayed along the X axis and correspond to data points.
One or more hierarchies can be added to the SLICERS field of the Data Analysis Panel for filtering purposes.
SLICERS hierarchy members are not rendered visually. They are used purely to filter the data values appearing in the visualization. Slicer values also cannot be displayed within tooltips.
Click the click to add link in the SLICERS field.
You'll see a list of hierarchies available to be added as a slicer. Scroll down and select the OnlineOrderFlag hierarchy.
The Country hierarchy is added to the SLICERS field.
Next, click the Edit icon to the right of the Country hierarchy. This opens the Configure Metric Set Element dialog.
Adjust the Caption. Click the Default Parameter Value dropdown list and select a hierarchy member value (e.g. True) to filter by. Then click Submit.
The table visualization is now filtered to show measure values corresponding to the selected member instead of all.
One or more hierarchies can be added to the COLUMNS field of the Data Analysis Panel for grouping purposes. You use this field when you want to see a column of data for each hierarchy member value or unique combination of values.
COLUMNS hierarchy members appear as the column headers of a table visualization.
Each column within a grouping represents a series of data points.
On a bar chart visualization, each COLUMNS hierarchy member corresponds to a series of data points (bars), where each series is colored differently by default.
7. See also
- Video: Creating and Viewing Dashboards
- Video: Creating and Using Filters on a Dashboard
- Create a metric set and add a filter
- Understanding the Dundas BI data model