Create Intervals of every 15 minutes

[rustyfishbones]

Hi All,

I need to get this in a hurry.

I have a Calculated Dimension TIME(class(aggr(Time,Time),.25/24)) which gives me intervals of every 15 minutes

I want to create this in the Script, how can I do it

Regards

Alan

[swuehl]

Have you tried:

Time( class( TIME, .25/24)) as TimeBucket

TIME being your time field

[rustyfishbones]

Hi Swuehl,

I am getting all results as 00:00:00, do I need to format as Time hh:mm

Regards

Alan

[sivarajs]

Try this

Timestamp(floor(frac([Your field])*96)/96+floor([Your field]),'m/d/yyyy hh:mm TT') //96 rounds to 15 mins

[Anonymous]

Alan

Have look at Henric's blog post on this called The Master Time Table

Best Regards,     Bill

[hic]

If swuehl 's formula returns zero all the time (00:00:00), then your field TIME cannot be interpreted correctly... You probably need to interpret the field using Time#().

HIC

[rustyfishbones]

Hi Henric

I am getting my Time field from the original [Time-added], and for this I have to reformat as below

So to get the TimeBucket Interval I require I tried what you see below (line2)

Am I even close to getting what I need?

[rustyfishbones]

maybe I need to add the format in before the format out?

[hic]

I think you make it too complicated...

First of all, if you load [Time-added] as it is - no formatting, no anything - what do you get then? A string? Or a number? And what does the string look like?

Secondly, you use a formatting function Num() inside your Time#() function. This may destroy whatever information you might have in the field... Normally, you should have an interpretation function inside your formatting function, i.e. Time(Time#(...))

HIC

[rustyfishbones]

Henric,

My [Time-added] lookslike this