Editing a Dimension

To edit the properties of a dimension in a chart, follow the steps below:

1. Click on the chart to select it. This opens the Data Source panel and the Binding panel.

2. Click the 'Edit Dimension' button next to the desired field in the Binding panel, and select the desired sorting or ranking option.

 

3. Click the 'Apply' button (green arrow).

Note: A measure must be defined in order to rank or sort by value.

The following settings are available:

Sort

Change the ordering of the X-axis labels:

None: Use the default label order.

Ascending: Place the labels in alphabetically ascending order.

Descending: Place the labels alphabetically descending order.

By Value(Asc): Place the labels in ascending order based on the selected measure.

By Value(Desc): Place the labels in descending order based on the selected measure.

Manual: Click the 'Edit' button to open the 'Manual Ordering' dialog box, and manually reorder the X-axis labels. This automatically creates a custom named grouping with the desired ordering. To remove the manual sort, simply clear the named grouping. (See below.)

Ranking

Filter the axis labels by aggregate measure value.

None: No ranking of X-axis labels.

Top: Select the top N labels based on the selected measure.

Bottom: Select the bottom N labels based on the selected measure.

Named Group

Select a predefined named group from a Data Worksheet (see Creating a Named Grouping in Data Mashup), or specify a custom named grouping. See Named Groups for information on how to design a named grouping.

Level

Set the grouping level for dates. Note the distinction between options such as 'Month' and 'Month of Year': The 'Month' option groups each date according to composite month and year, e.g., Jan'07, Feb'07, ..., Dec'07, Jan'08, Feb'08, ..., Dec'08. The 'Month of Year' option groups each date strictly on the month component, e.g., Jan, Feb, ..., Dec, so that each group may include data from multiple years. Likewise, for the other 'of Year/of Month/of Week/of Day' options.

As time series

Specifies that gaps in Date data should be retained. For example, if the data in the chart is grouped by month, and there is no data for the month of June, the 'As time series' property ensures that the month of June is still retained in the chart. To change the way that the gap is displayed, see Plot Property.

<< 6.6.6 Editing Dimensions and Measures © 1996-2013 InetSoft Technology Corporation (v11.5) Editing a Measure >>