Guest User

Untitled

a guest
Jun 19th, 2018
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. +------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+
  2. | Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
  3. +------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+
  4. | Customer 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |
  5. | Customer 2 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |
  6. | Customer 3 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
  7. | Customer 4 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 |
  8. +------------+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+-----+
  9.  
  10. Jun (or 6 as column index) for Customer 1
  11. Sep (or 9 as column index) for Customer 2
  12. Oct (or 10 as column index) for Customer 3, since the last 3-month occurrence begins at Oct instead of Sep
  13. NA for Customer 4, since there's no such an occurrence
Add Comment
Please, Sign In to add comment