AnsweredAssumed Answered

6am to 6am Running Total in AF

Question asked by ElizabethDouglas on Jan 27, 2020
Latest reply on Feb 19, 2020 by aewan

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'.

Using TagTot()


Any help would be great. We are at a loss.