Count new and lost projects per month

[Daniel26]

Hello!

I am looking for a way to count new and lost projects per month and per company.

My data looks as follows:

Company	Month	Project
100	06-2024	100_1
100	06-2024	100_2
100	06-2024	100_3
100	07-2024	100_1
100	07-2024	100_2
100	07-2024	100_4
100	07-2024	100_5
300	06-2024	300_1
300	06-2024	300_2
300	06-2024	300_3
300	06-2024	300_4
300	07-2024	300_1
300	07-2024	300_5

So I have unique project-numbers for every company and those can change from one to another month. I would like a table where I can see the number of projects per month and the number of new and lost projects from the last month. Something like this:

Company	Month	Num Project	New Project	Lost Project
100	07-2024	4	2	1
300	07-2024	2	1	3

I have tried different approaches, but I was not able to find the right function or set analysis statement yet. I hope you have an idea to solve my problem.

Thank you!

Best regards,

Daniel

[MatheusC · Accepted solution]

@Daniel26 

Check out this example of the top 10 visualization tips for new, returning, and lost customers. You can use this same logic.

- Matheus

[Daniel26]

Hi @MatheusC !

Great, I was able to solve it using the logic you posted.

Thanks a lot, fantastic support.

Best regards,

Daniel