I am struggling to create 15min interval using datetime & value fields.
Basically I am trying to calculate/display number of people count at that given time within the 15min interval based on the value.
Calculated field: datetime (15min Interval) - addDateTime((extract(‘MI’, datetime) % 15), ‘HH’, datetime)
Hi folks. I was able to get @Max solution to work in Analysis - thanks. I am wondering about in Dataset preparation - it fails there.
I have two separate datasets that i would like to Join via Data Time. Each dataset reports within a 15 minute window but is off by a minute or two of each other. With no coherence in the minute the Join response is bad.
I had hoped to create a calculated field for each dataset that rounds the time to the 15 minute block, following @faisalchohan, however I get the error (see red text image below) - using many variations of the snippet below.
Any way of tweaking this to use in Dataset editing and calculated field creation to Join datasets?
