14 Replies Latest reply: Dec 9, 2011 1:00 AM by ravimandre RSS

    How To create a calculated dimension using timestamp intervals

      Hello,

      I am attempting to create a bar chart with a calculated dimension that shows 30 minute increments using a timestamp field. I attempting to use the class function - class(minute(timestamp), 30) and I am not having any luck. Any help/suggestions would greatly be appreciated. Thanks

      dimension result example: 6:00 AM - 6:30 AM, 6:31 - 7:00 AM, 7:01 - 7:30, etc