KNOWLEDGE BASE

Google Analytics Date Field Is Empty


Published: 04 Jun 2015
Last Modified Date: 03 Aug 2015

Issue

In Tableau Desktop 9.0.2, when you create a connection to a Google Analytics data source, or refresh an extract of an existing Google Analytics data source, date fields might be empty.

Environment

  • Tableau Desktop 9.0.2
  • Tableau Server 9.0.2
  • Google Analytics

Resolution

Option 1

Upgrade to Tableau Desktop and Tableau Server to 9.0.3 or a later version. For more information, see Upgrading Tableau Desktop.

Option 2

Convert the field to a date by using a calculated field.
  1. Select Analysis > Create Calculated Field.
  2. Enter the following formula, and then click OK:
DATE( MID([Date], 5, 2) + "/" + RIGHT([Date], 2) + "/" + LEFT([Date], 4))

Cause

This issue occurs when Tableau Server interprets the ga:date field as a string instead of a date. This behavior has been corrected in more recent releases.
Did this article resolve the issue?