Count valid dates grouping by client

[matheusld2]

Hello!

I hope you're doing fine! 

I need to count valid proposals per customer. Each proposal is valid for 15 days. The number of proposals sent to the client is dynamic and changes every month. Any ideas on how to do this?

*date format : dd-MM-yyyy

Thanks!

[Robin_McIntosh · Accepted solution]

@matheusld2 - How's this?

[matheusld2 · Accepted solution]

@Robin_McIntosh  Thanks for your reply!

I tried your solution but I think we still need some adjustments

The difference between dates on rows 3 and 4 is 7 days, so only the last row should be counting 

[Robin_McIntosh]

@matheusld2 - But they are different proposal ids and both are within 15 days of today.  So I guess I'm not understanding the actual request.  If you are only looking for the most recent proposal per client, then you'd only be pulling in one count regardless.  Do you have more deetailed input data example with expected output example?