Intervals from Starting time to end time

[#1]

hi,all

here in the interval size chart(pivot table) i used calculated dimension with script below

=Aggr(

Dual(

(Time(Floor([Time In],1/"Interval Size"),'h:mm:ss TT')&'-'&Time(Ceil([Time In]+0.0000001,1/"Interval Size"),'h:mm:ss TT')),

Floor(Frac([Time In]),1/"Interval Size")),[Time In])

what i need is here there is no information in between 6:00 to 6:30 but i need this interval also

the dimension intervals is some thing like this (if 1/2 hour is selected)

5:00:00 AM-5:30:00 AM

5:30:00 AM-6:00:00 AM

6:00:00 AM-6:30:00 AM

6:30:00 AM-7:00:00 AM

.

.

.

.

3:00:00 PM-3:30:00 PM

and  (if 15 minutes is selected)

5:00:00 AM-5:15:00 AM

5:15:00 AM-5:30:00 AM

5:30:00 AM-5:45:00 AM

5:45:00 AM-6:00:00 AM

.

.

..

3:15:00 PM-3:30:00 PM

please reply me

[marcus_sommer]

If you are missing some buckets you will need to create these missing data, see: How to populate a sparsely populated field. Helpful in this case might be also to create those time-buckets (in several fields which are then used within a dimension-group) within the script within a master time-table: The Master Time Table especially by larger datasets are such calculated dimensions quite slow and you couldn't also refer to them like to a native field.

- Marcus

[Anonymous]

Hi Hemeswara,

Please can you post sample data.

Regards

Neetha