Count valid dates grouping by client

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!

Workflow

Datasets

Tips and Tricks

Date Time

Dynamic Processing

Data Investigation

Accepted answers

Robin_McIntosh

@matheusld2 - How's this?

Discussion_Count_Valid_Dates_Grouped.yxmd

matheusld2

@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

All comments

Robin_McIntosh

@matheusld2 - How's this?

Discussion_Count_Valid_Dates_Grouped.yxmd

matheusld2

@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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703