Tkennebrew
New Member
- Joined
- Oct 18, 2017
- Messages
- 3
Good evening. I am developing a trend analysis of data that has a start and end date. I need to count the number of rotations that were active every month that falls within the start and end date range.
A rotation starts 1 Oct 16 and ends 4 Apr 17. When I go to count how many active rotations that I had in October, November, December, January March, and April, I need the dates of this record to tally across the months so I can add them up for a total count. I hope this makes sense. I've added a bit of the data that I am working with. I've been after this for some time now.
Thanks in advance!
<tbody>
</tbody><colgroup><col><col><col><col><col span="3"><col span="6"></colgroup>
A rotation starts 1 Oct 16 and ends 4 Apr 17. When I go to count how many active rotations that I had in October, November, December, January March, and April, I need the dates of this record to tally across the months so I can add them up for a total count. I hope this makes sense. I've added a bit of the data that I am working with. I've been after this for some time now.
Thanks in advance!
10/1/2016 | 11/1/2016 | 12/1/2016 | 1/1/2017 | 2/1/2017 | 3/1/2017 | 4/1/2017 | 5/1/2017 | 6/1/2017 | ||||
10/31/2016 | 11/30/2016 | 12/31/2016 | 1/31/2017 | 2/28/2017 | 3/31/2017 | 4/30/2017 | 5/31/2017 | 6/30/2017 | ||||
Rotation Start | Rotation Completed | Active - Inactive | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
12/11/2016 | 4/7/2017 | Inactive | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | |
1/16/2017 | 2/10/2017 | Inactive | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | |
8/1/2015 | 6/3/2016 | Inactive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
2/5/2017 | 6/2/2017 | Inactive | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | |
2/6/2017 | Active | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | ||
2/22/2016 | 6/21/2016 | Inactive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
1/1/2017 | 5/1/2017 | Inactive | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 |
<tbody>
</tbody><colgroup><col><col><col><col><col span="3"><col span="6"></colgroup>