TimeStamp field (Date Time) (Cross Table Wizard - Step 3)

Column or Row

If you move a timestamp field in the Cross Table Wizard Step 3 to the columns or rows location, you will be prompt to select a level for that field, displayed in the following dialog box:

By default the Group Field will apply to the entire value, but you can ask to group the field by year, quarter, month, day of month, hour, minute or second (default is Value). You can add several levels, for example a first level on the year, then a level on the quarter, then a level on the month etc.

Note the <Delete> button that can be used to remove the field in the Column or Row areas. You can also press the <Del> key to remove a field in these areas.

Data

If you move a timestamp field in the Cross Table Wizard Step 3 to the data location, a CountVal function is applied by default to that timestamp field. You can then, if necessary, make a double click on that field to display the Group Field dialog box and modify the function to another:

For a timestamp field the following functions can be applied:

The Minimum value for that field: the oldest timestamp value.

The Maximum value for that field: the more recent timestamp value.

The CountVal value for that field: the number of not null occurrence for the field.

The Count(*) value for that field: the total number of occurrence for the field, including null values.

Note the <Delete> button that can be used to remove the field in the Data area. You can also press the <Del> key to remove a field in this area.