SOLVED
How to Count Records within Active Period
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
owenkosnen
8 - Asteroid
‎08-12-2020
12:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have a question that I have been stuck for few days, I'd like to count number of records that are within the range of period start and period end, and group them on monthly basis.
Below screenshot pretty much illustrates what I am trying to achieve.
For exp: person A, will be counted as 1 for period of Jan, Feb and Mar, and so on.
Any tips would be much appreciated. Thanks in advance!
Solved! Go to Solution.
Labels:
3 REPLIES 3
grazitti_sapna
17 - Castor
‎08-12-2020
12:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎08-12-2020
12:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-12-2020
01:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! This is exactly the answer I am looking for.
