How to check for consecutive monthly buys

datalady

i have a dataset that has purchasing history for many items for the past 10 years, i want to pull out only the items that have been purchased every month for the last 10 years. how do i go about this?

Operating system used: macos

Turribeach

There is probably many ways of doing this but I would do it this way. First create a list of all the months / years combination for the last 10 years. Say that gives you 120 rows. Then group your data by product, count distinct(month/year), sum(purchase_amount) where count distinct(month/year) = 120. Then you can use the list of prodcts to filter other datasets.