Bucket definitions are configured in the Report Bucket Definitions application. You can use a previously created definitions in your interactive reports, or create your own. The same definition can be reused in multiple reports since it defines the criteria for how the data should be organized, but is not built over a specific application table. 

Bucket definitions create columns with specified date ranges. Records are then sorted into those columns based on the type of bucket configured. A bucket definition sorts records in one of the following ways: 

• Relative Date—The records in the report are organized based on date ranges which are relative to a specific date.
• Relative Period—The records in the report are organized based on date ranges which are relative to a specific period within a fiscal year.

To view examples of how bucket definitions group the data, see Report bucket example.

Add a bucket definition to your report

In the Bucket Definition section of your interactive report, you must:

• Select the type of bucket definition you want in your report. You can choose either Relative Date or Relative Period. 
• Select the field which holds the date value that determines whether a record fits into a bucket column.
• Optionally, use the asterisk * key to review available bucket definitions. If no definition is selected, users can choose which one to use at runtime. 
• Enter any default inputs you want for the definition. 

Once you have added a bucket definition to your interactive report, you can add it to different table layouts and report versions. Bucket definitions can only be added as pivot fields.

When you open the Report Viewer, you can select any bucket definition which you have added to your report, or change the default inputs.