Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
using yours dimension it can be:
=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_min_nr)/10)*10)
you can use calculated dimension
=maketime(Hour(time),floor(Minute(time)/10)*10)
using yours dimension it can be:
=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_min_nr)/10)*10)
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!
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
=year(date_field)&'-'&num(week(date_field),'00')
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?
try to sort by expression:
=min(IN_DATE_creation_date))