Timeinterval hour:min 01:10 01:20 01:30

[#1]

Goodmorning,

I want to create an chart wich displays data every 10 mins.

Currently i have an in_date_creation_hour_nr i want to transform this into

<hour>01:<minute>10   01:20   01:30   01:40   01:50    2:00    2:10 and so on.

i have also a table with minutes, in_date_creation_min_nr

Thanks in advance!

[#2]

you can use calculated dimension

=maketime(Hour(time),floor(Minute(time)/10)*10)

[#3 · Accepted solution]

using yours dimension it can be:

=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_min_nr)/10)*10)

[#4]

Pari Pari wrote:

using yours dimension it can be:

=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_min_nr)/10)*10)

=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_date)/10)*10)

Works, thanks for the quick reply!

[#5]

I want to do the same for week numbers, tried some combinations but not getting the wanted result yet.

what i want is :

YEAR - WEEKnumber

2011-52

2012-01

2012-02

2012-03

and so on

[#6]

=year(date_field)&'-'&num(week(date_field),'00')

[#7]

Looks nice i'm getting there.

Only thing i run into now is the sorting.

Its currently like:

2012-05    2012-03     2012-04     2012-19

Tried the following things:

Sort by:

Expression

IN_DATE_creation_week_nr

or

=week(IN_DATE_creation_date)

Sort by:

Number

But none of the above works.. any suggestions?

[#8]

try to sort by expression:

=min(IN_DATE_creation_date))