This content has been marked as final. Show 2 replies
I've a date/time field (field name as Timestamp) in my Data Model.
Records of that field are like 2012-05-03 08:34:25, 2012-05-03 09:54:15, 2012-05-03 20:44:20 etc.
Currently i'm using time(frac(Timestamp),'h:mm tt') which is giving the value like 8:34 AM, 9:54 AM, 8:44 PM
I want to group them in every 30 min so that it shows 8:00 AM, 8:30 AM, 9:00 AM etc in my dimension.
Thanks and Regards,