I want to build an analysis in AF that will calculate a running total that resets daily from 6 am to 6 am. The big issue is the part between midnight and 6 am. The whole offset in the calculation makes everything a little more difficult. I and others at my site have tried doing this a hundred different ways each more complicated than the last. We would like to do this for many different tags so if we could figure out a way to do this simply and be able to transfer it to different tags would be great.
Things we have figured out so far:
Periodically triggered, every hour.
Series of If/Then statements.
Referencing time with '*" and 'y' and 't' along with +/- '6h'.
Any help would be great. We are at a loss.