Looking for way to do daily averages in af analyses, different locations have different start of day time, so have to make it be able to handle these difference.

I am sure there are many ways to do this, looking for some options (I am not that good yet at parsting and putting timestamps together in af.....is there a good document on effectively using various date/time gymnastics to manipulate for data retrieval?

One idea possibly is to use a PI point which is updated once a day which is a timestamp point could be used to drive an event based calculation, other ideas?

One simple approach is to set an attribute with the locations specific start time, and use that to dynamically calculate your summary calculation start and end times. A quick and dirty example might look like this:

Attribute to show Start of Day at location

Analysis configuration

Results:

Undoubtedly you could name your variables differently to give them more intuitive identifiers, and there's probably more elegant ways to do this, but it's a simple approach that might work for you.