2 Replies Latest reply on Nov 20, 2013 4:57 PM by Shawn Wallwork

    date and time

    Alexander Rom

      http://kb.tableausoftware.com/articles/knowledgebase/combining-date-and-time-single-field

       

       

      So, i've been trying to combine date and time into a single field, and the above calc. field isn't working. here is what I have

       

      One excel column is 'Date' (1/11/2013) the other is Time of Day (only top of the hour) stylized as 8:00pm tableau translates it to military time, but I digress. I wrote the below calc. field and I keep getting NULL for my values

       

       

       

       

      I am trying to show GA site visits by day by hour

       

      DATETIME(STR([Date] )  + " "

      + STR(DATEPART('hour',[Time of Day])))

       

      Any insight would be great as the Tableau Tech Support always seems to be non-existent lol