2 Replies Latest reply on Dec 30, 2016 2:57 AM by Ben Powis

    Date appearing as 'null' in published data source

    Ben Powis

      Hello everyone,

       

      I am having issues with my date field appearing as 'null' when I publish my data source to Tableau Online. My date is coming from BigQuery, when I run the query in Tableau desktop it works fine, but when I publish to online the reports come up with an error, when I view the data pane on a report which is connected to the online data source date is showing as 'null. Has anyone encountered anything similar?

       

      Here is my query:

       

      SELECT [date] AS [date], COUNT([hits.eventInfo.eventAction]) AS [Events], [hits.eventInfo.eventAction] AS [hits_eventInfo_eventAction], [hits.eventInfo.eventLabel] AS [hits_eventInfo_eventLabel], [device.deviceCategory] AS [device_devicecategory]
      FROM (TABLE_DATE_RANGE*REMOVED*], DATE_ADD(CURRENT_TIMESTAMP(), -6, 'DAY'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))), (TABLE_DATE_RANGE([*REMOVED*], DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'), CURRENT_TIMESTAMP()))
      WHERE [hits.eventInfo.eventCategory] = "TopNav Click"
      GROUP BY [date], [hits_eventInfo_eventAction], [hits_eventInfo_eventLabel], [device_deviceCategory]
      

       

      Thanks,

      Ben