Create a Time Bucket for every minute

[rustyfishbones]

Hi All,

I have created time buckets before for hours and every 15 minutes.

I need to create a time bucket for every minute in a Day, I am creating this at the moment from a time field, however I need to create one for every minute regardless if that minute exists in my time field.

I need to create a chart that shows 1440 minutes for each day and then show transactions for each minute on the chart, so I need to show the minutes even if no transactions happened

Regards

Alan

[Peter_Cammaert]

Do as you would do with a Master Calendar that should show all dates, even if there weren't any sales on some of them: create a time bucket definition that is external to your "facts". You can easily make this a continuous range without holes. Then link these to your transations. Use whatever key you like.

Best,

Peter

[rustyfishbones]

Thanks Peter,

But I need a Min and Max time, so I would need 00:00 and 23:59 to be in my Data set to get all minutes between those times, is that correct?

Regards

Alan

[#4]

Hi Alan,

Try something like the attached file.

Kind Regards,

Footsie

[ToniKautto]

How about a continuous axis in the chart? That should cover the missing times.

[Peter_Cammaert · Accepted solution]

Not really. You can start from whatever value you want, and create a range to whatever final value.

For example, a LOAD...AUTOGENERATE 1440; creates exactly the amount of rows you need. RowNo()-1 will indicate the current minute value.

Edit: not IterNo(). RowNo() or RecNo() will work.