Forum Discussion
How to Get Your Question Answered Quickly
Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Hello! I have a table with date and customer id. Do you need to calculate how many months the client used the services? I am attaching a table with an example and the result. Thank you!| Date | CustomerID |
| 01.10.2023 | 24 |
| 01.10.2023 | 24 |
| 01.10.2023 | 123 |
| 01.10.2021 | 124 |
| 01.10.2021 | 124 |
| 01.10.2023 | 126 |
| 01.10.2023 | 126 |
| 01.01.2022 | 24 |
| 01.02.2021 | 24 |
| 01.03.2021 | 245 |
| 01.04.2022 | 245 |
| 01.04.2023 | 245 |
| 01.07.2023 | 245 |
Result:
| CustomerID | Result (Count Month Active Customer) |
| 24 | 4 |
| 123 | 1 |
| 124 | 1 |
| 126 | 1 |
| 245 | 4 |