How to create 24 hr Time Field as Dimension???

[300sss300]

Hi Guys!

I have following field in table. I want to create Field to be used as dimension in chart to see sales based on Time e.g 1am 2am to 12 am.

is there any way to do that?

"Date and Time is in single cell"

Transaction Date

1/1/2015 10:47

1/1/2015 22:24

1/1/2015 7:17

Thanks

sunindia‌swuehl‌brunobertels‌yujiyamane‌MarcoWedel‌

[brunobertels]

Hi

try this

Hour(Timestamp("Transaction Date",'DD MMMM YYYY hh:mm:tt')) as "Time",

Bruno

[sunny_talwar]

Try this in your chart:

LOAD [Transaction Date],

          Time(Frac([Transaction Date]), 'hh TT'), as Hour

FROM Source

Update: Assuming [Transaction Date] is read as a timestamp, if not then you will have to use TimeStamp#() function here

Time(Frac(TimeStamp#([Transaction Date], 'MM/DD/YYYY hh:mm')), 'hh TT') as Time

Assuming Transaction Date is MM/DD/YYYY, if it is DD/MM/YYYY, change the above (red) part to DD/MM/YYYY

[300sss300]

Thanks !

[300sss300]

Thanks!