Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Custom Time Zone Considerations

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Custom Time Zone Considerations

            Keep these considerations in mind when working with custom time zones.

            Required Editions

            Available in Salesforce Classic and Lightning Experience.
            Available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in: Developer Edition
            Create Data Source Links in a Time Zone Enabled Dashboard
            You can create data source links using date fields (DateOnly and DateTime) in time zone enabled datasets. If two datasets are linked using the parent date field (such as CreateDate), all components of the date field (such as year and year-month) are automatically linked.
            Data source links between a static step and an individual date component of a DateOnly or DateTime field aren’t supported.
            Bind Dates in a Time Zone Enabled Dashboard
            When binding dates in a time zone enabled dashboard, you refer to date fields differently. Note the following differences between GMT-only dashboards and time zone enabled dashboards.
            GMT-Only Dashboards Time Zone Enabled Dashboards
            cell(myStep.selection, 0, "CloseDate_year") cell(myStep.selection, 0, "year_CloseDate")
            cell(myStep.selection, 0, "CloseDate_year~~~CloseDate_month") cell(myStep.selection, 0, "year-month_CloseDate")
            asEquality("CreateDate_year", "Region") asEquality(["year", "CreateDate"], "Region")
            asDateRange("CreateDate('year', 'month', 'day')") asDateRange("CreateDate")
            Use Compact Form Queries in a Time Zone Enabled Dashboard
            When adding dates in compact form queries, the syntax is different in time zone supported dashboards. Note the following differences between GMT-only dashboards and time zone supported dashboards.
            Query Component GMT-only Dashboards Time Zone Supported Dashboards
            Date Measure 
            "measures": [
    ["sum", "Ship_Date_day_epoch"]
]
            		 
            "measures": [
    ["sum", ["epochDay","Ship_Date"]]
]
            Group by Date 
            "groups": [
    "CloseDate_Year"
]
            		 
            "groups": [
    ["year", "CloseDate"]
]
            Group by Date 
            "groups": [
    [
        "CloseDate_Year",         
        "CloseDate_Quarter"
    ]
]
            		 
            "groups": [
    ["year-quarter", "CloseDate"]
]
            Filter by Date 
            "filters": [
  [
     "Created Date",
     [
         [
            1359504000000,
            1486425600000
         ]
     ],
     ">=<="
  ]
]
            		 
            "filters": [
  [
    "Created Date",
    [
       [
          "2013-01-30 00:00:00",
          "2017-02-02 23:59:59"
       ]
    ],
    ">=<="
  ]
]
            Filter by Date 
            "filters": [
  [
    "Opportunity.CloseDate",
      [
        [
          [
            "quarter",
            -2
          ],
          [
            "quarter",
            0
          ]
        ]
      ],
      ">=<="
  ]
]
            		Unchanged
            Order by Date 
            "Order": [
 [
  "CreateDate_year", 
  {
   "ascending": true
  }
 ]
]

            "order": [
  [
   ["year", "CreateDate"],
   {
    "ascending": true
   }
  ]
]
            Other Considerations
            You can’t view converted date-time values in a lens.
            Time zone enabled dashboards don’t support these features:
            • Notifications
            • Subscriptions
            • Watchlists
            • Natural language queries
            • Data source connections between a static step and a dataset date field
            • Displaying month names, such as “Jan” and “Feb” (months display as numbers only, such as “01” and “02”)
            • Remote text-based search on date fields in list widgets
             
            Loading
            Salesforce Help | Article