Banding date variables
Sample Script File: SpecialElements.mrs
This example script is based on the Museum sample data set. See
Running the sample table scripts for information on running the example scripts.
DataCollection.FinishTime{January 'January' expression('DataCollection.FinishTime.Month() = 1'),
February 'February' expression('DataCollection.FinishTime.Month() = 2'),
March 'March' expression('DataCollection.FinishTime.Month() = 3'),
April 'April' expression('DataCollection.FinishTime.Month() = 4'),
May 'May' expression('DataCollection.FinishTime.Month() = 5'),
June 'June' expression('DataCollection.FinishTime.Month() = 6'),
July 'July' expression('DataCollection.FinishTime.Month() = 7'),
August 'August' expression('DataCollection.FinishTime.Month() = 8'),
September 'September' expression('DataCollection.FinishTime.Month() = 9'),
October 'October' expression('DataCollection.FinishTime.Month() = 10'),
November 'November' expression('DataCollection.FinishTime.Month() = 11'),
December 'December' expression('DataCollection.FinishTime.Month() = 12')}
This example creates an axis based on the
DataCollection.FinishTime date system variable and uses the
Month function in custom expressions to automatically band the dates into categories based on the month.
Here is a table that has this axis on the side (a hide rule has been used to hide the all-zero rows):
See also
