4.4.2  Editing a Dimension

The Chart Editor automatically categorizes non-numerical fields of a Data Block as “dimensions,” unless otherwise specified. Typically, dimensions are represented on the X-axis or expressed as a subseries (i.e., 'Visual' binding). Dimensions can also be used in the 'Break By (Dimension) / Tooltip (Measure)' field of the Data panel.

To edit the representation of a dimension, click the 'Edit Dimension' button in the Data panel. This opens the options panel.

 

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

The following settings are available. Note that a field of type Date has additional grouping level options.

Sort

Change the ordering of the X-axis labels:

None: Use the label order as defined within the data block or cube.

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.

Ranking

Filter the axis labels by aggregate measure value.

None: No ranking of X-axis labels.

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

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

Group all others together

For Top/Bottom-N ranking, creates an “Others” category which represents (in aggregate) all the groups excluded by the Top/Bottom-N filter.

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 Editing Plot Properties.

The image below illustrates the effect of enabling the 'As time series' option.

 

See Also

Sorting a Chart Dimension by Value, for a quick way to sort chart groups by value.

<< Setting the Chart Style © 1996-2013 InetSoft Technology Corporation (v11.4) 4.4.3 Editing a Measure >>