Thank you for posting, this is very close to what I need. I would just need it to show a 1 for the first 3 entries, then a 2 for the next 3, and then a 3 for the 1/1/2017 entry. I'm basically trying to get a rolling count of how many 180 day periods they have visited.
This was a tough one! I think I figured it out, though. I'm SURE there are simple/elegant ways to do this, but hopefully this will get you going in the right direction.
First, I created a "180 Day Period" field, which creates a date that is 180 days after the initial visit date. But, if the next visit date is >180 days after the initial, it creates a "new" date that is 360 days after the initial visit date. If the next visit date is >360 days after the initial visit date, it creates a "new" date that is 540 days after the initial date. And so on...
Next, I created a field that determines whether the current Visit date is the first date within a given 180 day period:
Next, I did a sum of the previously created field:
Lastly, I changed Sum of Min Visit Date to a running total:
Here is the final product:
Incrementing a Count.twbx 40.5 KB
Thank you so much, this is awesome! I've been trying to learn how to work with the level of detail functions, this is an excellent example of how helpful they can be. I appreciate it!