Generate 48 Intervals Starting from 00:00:00 until 23:30:00

[Hiteshp]

Hello Team,

using the attached configuration i am able to generate the Intervals until 23:00:00 however when i change the configuration to 23:30:00 it starts computing the data on a large scale. 

[JamesCharnley · Accepted solution]

Hi @Hiteshp 

I can't actually seem to replicate what you're saying with the provided configuration. If you're only looking for the 48 intervals for time, I can get it by using an arbitrary date in the generate rows tool to create 48 rows, and then forcing it to a time afterwards. Is that what you're after? Or how do you need it to link to dates you already have?

[Christina_H · Accepted solution]

The difference here will be the inclusion of the date.  Without the date, your "final" time is 00:00:00, which comes before 23:30:00 so the whole cycle starts again.  With the date included, that final time is on the next day so escapes the loop.

[TimN]

Maybe this is a different Option... 

[Hiteshp]

Thank you this helps out