6.6.13  Setting Date Grouping Properties

When you use a date field as a dimension, you can specify the level of date grouping (month, year, etc.). To do this, click the 'Edit Dimension' button for the desired date field, and choose the desired grouping from the 'Level' menu.

 

If the data represents a series of measurements at uniformly-spaced time intervals, select 'As Time Series'. This forces the chart to display all measurement periods, even those for which no corresponding data is available. Otherwise, these “empty” periods are suppressed.

Figure 21. Effect of 'TimeSeries' option on display of missing data

 

It is important to set the format of the labels to the match the grouping level. For example, dates grouped by year should have a format such as “yyyy” to display just the year component of the date. For information on setting chart label formats, see Chart Properties.

<< 6.6.12 Rotating a Chart © 1996-2013 InetSoft Technology Corporation (v11.4) 6.7 Binding Data to a Section Element >>