Forum Discussion
Time interval
If you are using 15 minute buckets, why isn’t 10:26 highlighted?
10:12 would be in the '10:00 to 10:15' bucket whereas 10:26 would be in the '10:15 to 10:30' bucket.
OR do you mean that the bucket start resets based on something? If you mean a floating 15 minute bucket, the Time dimension's buckets won't help at all.
I need more details
Look at the Excel sheet the interval is reset everytime the running total reach 15 min
Remember 10:12 was the cutting point now we are in 0 again
therefore 10:26 - 10:12 = 14 (we need 1 more to get 15) than 10:32 - 10:26 = 6
6 + 14 = 20 is >= 15 yes so 10:32 is the correct result
In another word is the running total of delta need to reach 15 min and reset again to 0 and start over thats way your windows of 15 min bucket won't produce the expected result it has to be recursive like TSQL