9 Replies Latest reply on Apr 29, 2016 2:11 AM by Rajeshwari Guddeti

    How to get time separated from date time in Tableau.. Data is imported from Mongo and date format in mongo is "2016-02-01T11:23:05.000Z"..

    Rajeshwari Guddeti

      How to get time separated from date time in Tableau.. Data is imported from Mongo and date format in mongo is "2016-02-01T11:23:05.000Z"..

      When i have imported date data of format "2016-02-01T11:23:05.000Z"  from Mongo to Tableau. Tableau table displays it as 2016-02-01 11:23:05 AM..

      when i try to separate time data alone using "RIGHT(STR([Start Time]),9)", it gives me only last 9 digits something as 11:23:05..

      Now i want to plot a graph which shows me the time in ascending order for a given particular day.. As it is considered as string it doesn't give me order of time for a particular day..

      I want to see in a given particular day ascending order of times (eg: for a given day graph should start from morning 9:00:00 AM to 11:53:55)..  data should be sorted according to hours,minutes, and seconds..

      Can someone help me getting this done.. Any help would be kindly appreciated..