Hi All - I’m having trouble showing a certain set of data that is between 2 dates that are returned in a repeating group from an external API.
I’ve got a set of data in my Bubble DB that is time stamped, for example…
I am pulling down an array of info from an external API and placing it in a repeating group. Each of these rows are also timestamped. For example…
Event A, 12/31/2015
Event B, 1/1/2016
Event C, 1/4/2016
In my repeating group, I want to show the average of all the temperature records that fit between the current event and previous. So for my example, I would want to show on the row for Event C a value of 56.67 (avg of 55, 57, and 58).
I know I can put a constraint in my search for temperature records that are < than that of the current Event DateTime but I’m having trouble also constraining to records that are > than that of the previous row in the repeating group. I’ve been messing around with count #, index’s, etc but no luck yet. And the avg part is simple, I’m mainly just having trouble comparing/constraining with the previous (or next) record in a repeating group.
I’m not sure if this is the correct approach at all so any advice would be appreciated!