Hello All,
I have a table containing partnername, license count, activationdate, date of association
On the basis of this I have to create a interval from 0 to 21+
month - I got from date of association
onboarded partners count- this I just put the partner'sname
now I have to calculate the last six month license count with partner slab , I am not sure as how can I create the intervals please advise..
| | | Last 6 months Avg Activation Slab wise Partner Count |
| Month | Count of Partners Onboadrded | 0 | 1-3 | 4-7 | 8-12 | 13-20 | 21+ |
| Oct'18 | 17 | 12 | 3 | 1 | 1 | | |
| Nov'18 | 26 | 24 | 2 | | | | |
| Dec'18 | 23 | 11 | 5 | 6 | 1 | | |
| Jan'19 | 24 | 15 | 2 | 5 | 2 | | |
| Feb'19 | 24 | 18 | 2 | 2 | 1 | 1 | |
| Mar'19 | 24 | 18 | 3 | 3 | | | |
| Apr'19 | 25 | 19 | 5 | 1 | | | |
| May'19 | 14 | 8 | 4 | 2 | | | |
| Jun'19 | 13 | 8 | | 4 | | | 1 |
| Jul'19 | 14 | 7 | | 4 | 2 | 1 | |
| Aug'19 | 19 | 11 | 3 | 2 | 1 | 2 | |
| Sep'19 | 7 | 5 | 2 | | | | |
