Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a below table where I need a count of partnername who installed average 1 license in last three months.
Like we are in feb currently so the count should be taken from Jan2021, dec2020 and nov2020, and 1 license installed each month which leads to average count 1.
License Number - License number installed against sale (so it is basically 1 license number = 1 sale)
Partnername | licensenumber | installationdate |
A | 1656 | Jan-21 |
B | 1654 | Feb-18 |
C | 1590 | Jan-21 |
D | 1361 | Feb-19 |
A | 1234 | Feb-21 |
B | 1571 | Apr-21 |
C | 1981 | Apr-21 |
D | 1636 | Jan-21 |
D | 1602 | Feb-21 |
A | 1921 | Jan-21 |
B | 1725 | Feb-19 |
B | 1732 | Dec-20 |
C | 1706 | Nov-20 |
D | 1996 | Mar-18 |
Thanks
Can anyone please look into it?