Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Pivot Table with hours (3:00 pm) across the top and dates in the Column. My measure is the Count of ID, All of my numbers in the column are the same.
I have several lines of data with same date, I am trying to put the number of transaction into buckets of time.
Row = =(date(tdatetime))
Value (for time) =Timestamp(Floor([tdatetime], 1/24), 'h TT')
Measure = count(transid)
Any suggestions would be greatly appreciated.
Thank you
How about:
Row : Date(Floor(tdatetime))
This extracts the date component as number and displays it as a date
Column : =Round(Frac(DT)*24)
This will give you the hour (0 through 23). You can lay with the rounding to choose whether you want nearest (as above) or hour starting or hour ending. If you want to display it as an time stamp then divide by 24 again and format it using the timestamp function.
How about:
Row : Date(Floor(tdatetime))
This extracts the date component as number and displays it as a date
Column : =Round(Frac(DT)*24)
This will give you the hour (0 through 23). You can lay with the rounding to choose whether you want nearest (as above) or hour starting or hour ending. If you want to display it as an time stamp then divide by 24 again and format it using the timestamp function.
That is exactly what I was looking for. Thanks for responding so quickly.