4 Replies Latest reply: Mar 31, 2017 5:03 PM by Ajinkya Bhonsle RSS

    How to Pull the Day of the Week and time of the day from Date/time Field?

    Ajinkya Bhonsle

      Hi Everyone,

       

      I am looking to build a dashboard where I can show Email's Open day of week and time of day. I have a Date/Time Field called "Activity Date".

      Dimension:

      Activity Type: Email Opens, Website Visits, Form Submitted etc..

       

      I need to show the data in a timeline (time of day and day of week). For day of week I used the weekday([Activity Date]) function to pull out the week information.

      Something like this:

       

       

      Any suggestions on showing the data in time of day?