Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.
1. D1. 5 minute interval: DATETIME(INT(FLOAT([Datetime])*288)/288)
2. P1. Count Visit ID: count([Visit ID])
3. Drag required objects to the indicated locations.
5 min interval_nalmai_10.3.twbx 32.5 KB
The Float worked to get the times in line. Thank you. The issue I still have is with the count. For example i think it is looking at each specific float time interval to see if the ID is present. If the ID is not present at the time I still need to it include it in the count until it sees the next time frame where the ID is actually present.
This is what it looks like it is currently doing:
ID Float Time Calc Count(ID)
1234 7:00 1
1234 7:05 1
*No entry 7:10 0 <<Since there no entry for this time frame for the specified ID it will not include it in the total count when i add multiple ID's.
1234 7:15 1
An example is below, where we look into the time interval it is missing the record at 720, so then there is no count.
I need a way to create the 5 min intervals along the x-axis, but if there is no record I still want it to exist, otherwise I cant create a calculation for the count at that time. For example if you look at below – At 715 there is a record and at 725 there is a record so it shows the associated count of the ID. But at 720 there is no record so it doesn’t plot anything… Is there a simple way to handle this?