Hi,
i have a workflow that should flag each date against same 'top most par calc' if appears in previous 7 days. That part is working fine in the workflow.
I would like to create new field which will calculate number of repetition in the previous 7 days from current date. On screenshot below you can see where the problem is
as you can see, calculation i made is not restarting count based on current date, but counting all previous records.
Workflow is attached
Solved! Go to Solution.
This is quite a fiddly problem.
If I am understanding it correctly I suggest the following.
Create a running total for each 'top most par calc'
You can then create a set of dates with a 7d ago and 180d ago.
Then create a complete running count for all these dates filling in the gaps
Finally join this series back to the data and you can produce the counts
I have attached a sample doing this
Oh it's a complicated workflow. @jdunkerley79 :)
Unfortunately it is not giving me results that it should. I highlighted the wrong values