Count new and lost projects per month

Daniel26 — Tue, 16 Jul 2024 06:08:17 GMT

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

Re: Count new and lost projects per month

MatheusC — Tue, 16 Jul 2024 19:43:58 GMT

@Daniel26

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

- Matheus

Re: Count new and lost projects per month

Daniel26 — Wed, 17 Jul 2024 06:50:13 GMT

Hi @MatheusC !

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

Thanks a lot, fantastic support.

Best regards,

Daniel

topic Re: Count new and lost projects per month in App Development

Count new and lost projects per month

Re: Count new and lost projects per month

Re: Count new and lost projects per month