The Date Options and Worksheet Options appear in separate panes at the bottom of the Configuration window and are part of the Data Builder.
The Date Options pane in the Data Builder includes the following options:
The Table Options pane in the Data Builder includes the following options:
The Worksheet Options pane in the Data Builder includes the following options:
| Option | Function/Description |
|---|---|
| Chart Title | Indicates a title for the chart. MIMIC centers the chart title above the chart. |
When checked, skips all NaN values for the analysis. | |
| Skip Weekends | When checked, skips all weekend dates for the analysis. |
When checked, includes the summary statistics at the bottom of the table results. Summary statistics include the sum, average, etc. | |
When checked, enables Seasonal Analysis, allowing users to select a seasonal analysis based on seasons or averages. |
The Seasonal Analysis option is available in the Worksheet Options pane and allows users to configure worksheet data based on the season or seasonal averages. This option is available by checking Seasonal Analysis. The Seasonal Analysis Configuration window opens and includes two tabs: the Seasons tab and the Averages tab.
The Seasons tab in the Seasonal Analysis Configuration window includes the following options:
| Option | Function /Description |
|---|---|
Indicates a start date for the season. Users can enter or select a start date, or select the Calendar button to enter a start date. | |
Indicates an end date for the season. Users can enter or select an end date, or select the Calendar button to enter an end date. | |
When checked, adds changes to the start and end season entries. By default, Lock included seasons with date range is checked. When unchecked, users must select the Add button to choose the desired dates. | |
When checked, displays the results for the period in the resulting chart or table. Click the Add button to add a season to be included in the analysis. | |
Sets the execution units for the seasonal analysis (days, weeks, months, quarters). |
The Averages tab in the Seasonal Analysis Configuration window includes the following options:
| Option | Function/Description |
|---|---|
When checked, displays the average in a chart or table for all seasons entered under the Seasons tab. | |
When checked, enables the lower section of the tab. This option allows users to customize the years used for the average. Users can select the Add button to add years to the average, select the Edit button to modify the years chosen, or select the Delete button to delete the custom average. | |
Sets the execution units for the average (days, weeks, months, quarters). |