Create calendar measures

To analyze data over relative time ranges, use calendar measures. For example, you might want to compare current year-to-date sales figures with figures from the same period the previous year.

Calendar measures aggregate data from a field over a time range, and are saved in the Measures category in the master items. Calendar measures comprise a field to be aggregated, an aggregation, a date field, and a time range for that date field that sets which data is included in the aggregation. You create calendar measures under Fields in the Assets panel, using the Create calendar measures dialog.

You can aggregate fields from tables loaded in Data manager or from a script in Data load editor, as long as the field is in the same table as the date field, or is in an associated table.

However, the date field must be from a table that has been loaded using Data manager, because calendar measures use expressions tagged as date & time fields that are declared in autoCalendar, and date fields are only mapped to autoCalendar when loaded in Data manager. Calendar measures support the following aggregations with the aggregated field: Sum, Count, Avg, Min, and Max.

A calender measure can use one of the following time ranges are available for use with calendar measures: weekly, monthly, quarterly, and yearly. Within each time range, different measures exist for periods such as current month, year-to-date, and current week last year. The following time ranges and measures are available for creating calendar measures:

Once created, calendar measures are treated identically to master measures. That is, calendar measures are reusable and editable while an app is unpublished. Users of a published app will have access to the calendar measures, but will not be able to modify them.

Creating a calendar measure from a field

Do the following:

1. Click @Edit in the toolbar.

   The assets panel opens on the left-hand side.

2. Click H to open the Fields tab.

3. Right-click a field and select Create calendar measures.

   By default, the field you right-clicked will be included as the Aggregated field.

4. Select a date field from the Date field drop-down list.

5. Select a field from the Aggregated field drop-down list.

6. Select an aggregation from the Aggregation drop-down list.

7. Select a time range from the Time range drop-down list.

   A list of the available measures displays under Preview of measures.

   You can toggle the display of the measures' expressions by selecting the Preview of measures switch.

8. Select the calendar measures to add to your master items.

   By default, all measures are selected.

9. Click Save to master items.
10. Click Close.