Hi - in the below data set, I want to count the number of styles that have a break in their buying pattern. For example, I want to know that two out of the 4 styles don't have consecutive buys. Styles 2 & 4 would need identified as have a break in their buy pattern.
I would then make a KPI that 2 out of the 4 styles don't have consecutive buys per our buy calendar. 50% of the styles are not bought consectutively. Newer user, so I'm sure someone out there has the answer!
Solved! Go to Solution.
Well, you will certainly need to unpivot your date columns and almost certainly use EARLIER. What I am struggling with is the logic. So if something is bought once and never bought again, that is not a break in consequetive buying, only if something is bought, bought again, not bought and then bought again.
Also, are the dates presented just examples or would the dates really be every day? Or are these some kind of reporting period?
Proud to be a Datanaut!
Hi - thank you for replying. Yes, if something is bought once, that is a different metric, that's a "one time buy." The dates presented are per a buy date calendar, so sometimes there are gaps in between those dates. I want to know for a vendor the following:
1) One time buys
2) Consecutive buys
3) Non-consecutive buys
I hope that helps explain what I'm looking for. I figured out the one time buy metric, I just can't figure out what functions(s) will be needed to figure out those breaks in the buying pattern.
Hi - I played with this formula some more and it doesn't work. It doesn't tell the difference between a buying pattern without breaks vs. one that has breaks. I coverted it to DAX and it just gives the number of buys that aren't one time buys. Still working it, as the solution is proving to be evasive!
183012 should not show up below as having intermittent purchases.