Timestamp to stop at minute

[samuel_brierley]

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

[JonnyPoole · Accepted solution]

How about this:

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