Specify date conventions for Analytics dashboards and lenses.
1"dates" : [
2 {
3 "alias" : "Order_Date",
4 "label" : "Order Date",
5 "firstDayOfWeek" : -1,
6 "fiscalMonthOffset":0,
7 "fields" : {
8 "day" : "Order_Date_Day",
9 "epochDay" : "Order_Date_day_epoch",
10 "epochSecond" : "Order_Date_sec_epoch",
11 "fullField" : "Order_Date",
12 "hour" : "Order_Date_Hour",
13 "minute" : "Order_Date_Minute",
14 "month" : "Order_Date_Month",
15 "quarter" : "Order_Date_Quarter",
16 "second" : "Order_Date_Second",
17 "week" : "Order_Date_Week",
18 "year" : "Order_Date_Year"
19 }
20 },
21 {
22 "alias" : "Ship_Date",
23 "label" : "Ship Date",
24 "firstDayOfWeek" : -1,
25 "fiscalMonthOffset":0,
26 "fields" : {
27 "day" : "Ship_Date_Day",
28 "epochDay" : "Ship_Date_day_epoch",
29 "epochSecond" : "Ship_Date_sec_epoch",
30 "fullField" : "Ship_Date",
31 "hour" : "Ship_Date_Hour",
32 "minute" : "Ship_Date_Minute",
33 "month" : "Ship_Date_Month",
34 "quarter" : "Ship_Date_Quarter",
35 "second" : "Ship_Date_Second",
36 "week" : "Ship_Date_Week",
37 "year" : "Ship_Date_Year"
38 },
39 "showInExplorer" : false
40 }
41],The dates section can have the following parameters.
| Parameter | Description |
|---|---|
| alias | Identifier (API name) for the dataset field used to generate the date part fields in the dataset. For example, Order_Date generates Order_Date_Month and Order_Date_Minute. |
| fields | Array of the date part fields, like CloseDate*Day, CloseDate_Year, and CloseDate_Hour. Specify all date parts. If fiscalMonthOffset is set in the dataflow or XMD file for CSV data, you must also specify fiscal date parts, like CloseDate_Week_Fiscal. To specify a date part, use the format <date_field_name>*<date_part>. For example, for the week date part for the CloseDate field, enterCloseDate_Week. |
| firstDayOfWeek | This parameter is deprecated at the dataset level. You can set this property in the sfdcDigest transformation for Salesforce data or in the metadata (schema) file for CSV uploads (using the UI or External Data API). |
| fiscalMonthOffset | This parameter is deprecated at the dataset level. You can set this property in the sfdcDigest transformation for Salesforce data or in the metadata (schema) file for CSV uploads (using the UI or External Data API). |
| label | Display name for the dataset field, up to 40 characters. Example: "label": "Closing Date" |
| showInExplorer | (Boolean) Indicates whether the dataset field can be selected from the dashboard designer or explorer when creating dashboards and lenses. Even if showInExplorer is false, you can still use the field for SAQL queries, manually adding it in JSON, and accessing it using the Analytics REST API. Example: "showInExplorer": true |
In the dataset XMD file, if the user defines a label for a date field, the label value is used as the alias value for that field when the dataset is generated.
For more information about date parts and the first day of the week, see Date Handling in Datasets.
j