Timestamp to stop at minute

samuel_brierley — Wed, 04 Mar 2015 16:37:49 GMT

Hi all,

Im guessing this should be pretty quick fix for someone.

my data has a row for every 10 seconds (i.e 6 per minute).

what i want is to average those to minute values so what i did was in the load script the below

Time(SLO_Sim_Time,'hh:mm') as [Minute],

and then used Minute as the dimension.

this hasnt worked at all, i still have all 6 data points on my chart???

my current expression is =avg(Speed)

thanks for any help

Re: Timestamp to stop at minute

JonnyPoole — Wed, 04 Mar 2015 16:52:34 GMT

How about this:

time( maketime( hour( Time(SLO_Sim_Time)) , minute(Time(SLO_Sim_Time))) , 'hh:mm' ) as Minute