I have a database on InfluxCloud and I’m trying to group time data. The data is stored in UTC time of course, but I want to group it by day for various time zones. If I specify where time <= epoch of midnight in the appropriate time zone and do a group by time(1d) it seems to choose midnight GMT and group that way. I tried grouping by 86400010ms (1 day plus 10ms) and that seems to work. I also tried grouping by 24h, 1440m, etc and all of those had the same outcome as 1d.
Is there a way to group by a 1 day period and force Influx to use my start time as the grouping start point?