why is the timestamp not aggregrate

[n1ef5ng1]

Please see attached.

I have changed the timstamp in script to this

Date(timestamp#(Date,'MM-DD-YYYY hh:mm:ss'),'YYYYMMDD') as YYYYMMDD,

but when i try to create a pivot table with the calculation expression such as sum of sales etc.

the output is individual unique ID of identical YYYYMMDD where it is suppose to be aggregate

is there any step that i have missed.

thanks

[shraddha_g · Accepted solution]

Try

Date(floor(timestamp#(Date,'MM-DD-YYYY hh:mm:ss')),'YYYYMMDD') as YYYYMMDD

[n1ef5ng1]

how about time? i cant floor the time

   timestamp(timestamp#(Date,'MM-DD-YYYY hh:mm:ss'),'hh:mm') as TIme,

[shraddha_g]

It will aggregate at time level

[stabben23]

Try this for Time

time(frac(timestamp(Date,'hh:mm:ss')))  as Time